To submit Concurrent Request using the SSHR Page:
2.
SSWA jsp function
3.
For a Particular Program:
OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&programApplName=XXCUST&programName=XXEMPNOC&programRegion=Hide&scheduleRegion=Hide¬ifyRegion=Hide&printRegion=Hide
For any Program:
OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&scheduleRegion=Hide¬ifyRegion=Hide&printRegion=Hide
4. Attach the function to the Responsibility Menu of Self service.
5. it will not show directly to the Selfservice Menu we need to add under Custom Menu named
AE Self Service Functions Custom
6. Set the Profile Option at Site Level “MO: Operating Unit” , if not set will get an error in the page. (Doc ID 393560.1)
For
Parameters:
Payroll_id :
Default Type:
SQL Statement
SELECT
PAAF.PAYROLL_ID FROM PER_ALL_ASSIGNMENTS_F PAAF, PAY_ALL_PAYROLLS_F PPF WHERE
TRUNC(SYSDATE) BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
AND PAAF.PRIMARY_FLAG = 'Y' AND PERSON_ID IN (SELECT EMPLOYEE_ID FROM FND_USER
WHERE USER_ID = fnd_profile.value('USER_ID')) AND ROWNUM =1AND PAAF.PAYROLL_ID
= PPF.PAYROLL_ID
Person Id: (hidden)
Default Type SQL Statement
SELECT EMPLOYEE_ID FROM FND_USER WHERE USER_ID =
fnd_profile.value('USER_ID') AND ROWNUM = 1
Payroll_Action_id: (in rdf report AFTER PARAMETER FORM)
select distinct paa.payroll_action_id--,
ptp.time_period_id
into
:p_payroll_action_id
from
per_all_assignments_f paaf,
pay_payroll_actions ppa,
per_time_periods ptp,
pay_assignment_actions paa
where
ptp.time_period_id = ppa.time_period_id
and paaf.assignment_id = paa.assignment_id
and paa.payroll_action_id = ppa.payroll_action_id
--and paa.payroll_action_id = 2035382
and paaf.person_id = :p_person_id--26876
and ptp.time_period_id = :p_time_period_id-- 5010
No comments:
Post a Comment