eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SA_GOSI_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 214: ,pay_payroll_actions ppa

210: cursor get_pid_new (p_org_id number,p_date date) is
211: select distinct asg.person_id,paa.assignment_action_id
212: from per_all_assignments_f asg
213: ,pay_assignment_actions paa
214: ,pay_payroll_actions ppa
215: ,hr_soft_coding_keyflex hscl
216: ,per_periods_of_service pos
217: where asg.assignment_id = paa.assignment_id
218: and paa.payroll_action_id = ppa.payroll_action_id

Line 237: ,pay_payroll_actions ppa

233: --and trunc(pps.actual_termination_date,'MM') = p_date;
234: select distinct asg.person_id, paa.assignment_action_id
235: from per_all_assignments_f asg
236: ,pay_assignment_actions paa
237: ,pay_payroll_actions ppa
238: ,hr_soft_coding_keyflex hscl
239: ,per_periods_of_service pos
240: where asg.assignment_id = paa.assignment_id
241: and paa.payroll_action_id = ppa.payroll_action_id

Line 267: ,pay_payroll_actions ppa

263: -- Cursor to get person_ids,assignment_ids of newly joined emps
264: cursor get_pid_new (p_org_id number,p_date date) is
265: select distinct asg.person_id,asg.assignment_id from per_all_assignments_f asg
266: ,pay_assignment_actions paa
267: ,pay_payroll_actions ppa
268: ,hr_soft_coding_keyflex hscl
269: ,per_periods_of_service pos
270: where asg.assignment_id = paa.assignment_id
271: and paa.payroll_action_id = ppa.payroll_action_id

Line 286: ,pay_payroll_actions ppa

282: --Cursor to get assignment_action_id of new emps
283: cursor get_assact_id_new (p_org_id number,p_date date,p_person_id number) is
284: select paa.assignment_action_id from per_all_assignments_f asg
285: ,pay_assignment_actions paa
286: ,pay_payroll_actions ppa
287: ,hr_soft_coding_keyflex hscl
288: ,per_periods_of_service pos
289: where rownum < 2
290: and asg.assignment_id = paa.assignment_id

Line 311: ,pay_payroll_actions ppa

307: --and trunc(pps.actual_termination_date,'MM') = p_date;
308: select /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct asg.person_id, asg.assignment_id
309: from per_all_assignments_f asg
310: ,pay_assignment_actions paa
311: ,pay_payroll_actions ppa
312: ,hr_soft_coding_keyflex hscl
313: ,per_periods_of_service pos
314: where asg.assignment_id = paa.assignment_id
315: and paa.payroll_action_id = ppa.payroll_action_id

Line 353: ,pay_payroll_actions ppa

349: cursor get_assact_id_term (p_org_id number,p_date date,p_person_id number) is
350: select paa.assignment_action_id
351: from per_all_assignments_f asg
352: ,pay_assignment_actions paa
353: ,pay_payroll_actions ppa
354: ,hr_soft_coding_keyflex hscl
355: ,per_periods_of_service pos
356: where rownum < 2
357: and asg.assignment_id = paa.assignment_id

Line 1809: ,pay_payroll_actions ppa

1805: ,pay_action_contexts ac2
1806: ,ff_contexts ct2
1807: ,pay_action_contexts ac3
1808: ,ff_contexts ct3
1809: ,pay_payroll_actions ppa
1810: ,pay_run_results rr1
1811: ,pay_run_results rr2
1812: ,pay_run_results rr3
1813: WHERE ppa.business_group_id = p_business_group_id

Line 1935: ,pay_payroll_actions ppa

1931: ,pay_action_contexts ac2
1932: ,ff_contexts ct2
1933: ,pay_action_contexts ac3
1934: ,ff_contexts ct3
1935: ,pay_payroll_actions ppa
1936: ,pay_run_results rr1
1937: ,pay_run_results rr2
1938: ,pay_run_results rr3
1939: WHERE ppa.business_group_id = p_business_group_id

Line 1977: ,pay_payroll_actions ppa

1973: /******Code for fetching contribution of leavers******/
1974: cursor csr_get_leav_assact is
1975: select distinct paa.assignment_action_id, paf.person_id
1976: from pay_assignment_actions paa
1977: ,pay_payroll_actions ppa
1978: ,per_all_assignments_f paf
1979: ,per_periods_of_service pps
1980: ,hr_soft_coding_keyflex hscl
1981: ,per_time_periods ptp

Line 2005: ,pay_payroll_actions ppa

2001: /******Code for fetching contribution of saudi leaver employees paying only annuities*****/
2002: cursor csr_saudi_l_ann_assact is
2003: select distinct paa.assignment_action_id, paf.person_id
2004: from pay_assignment_actions paa
2005: ,pay_payroll_actions ppa
2006: ,per_all_assignments_f paf
2007: ,per_periods_of_service pps
2008: ,hr_soft_coding_keyflex hscl
2009: ,per_time_periods ptp

Line 2033: ,pay_payroll_actions ppa

2029: /******Code for fetching contribution of saudi joiner employees paying only annuities*****/
2030: cursor csr_saudi_j_ann_assact is
2031: select distinct paa.assignment_action_id, paf.person_id
2032: from pay_assignment_actions paa
2033: ,pay_payroll_actions ppa
2034: ,per_all_assignments_f paf
2035: ,per_periods_of_service pps
2036: ,hr_soft_coding_keyflex hscl
2037: ,per_time_periods ptp

Line 2844: ,pay_payroll_actions ppa

2840: cursor get_assact_id (l_assignment_id NUMBER, l_effective_date Date) is
2841: select paa.assignment_action_id
2842: from pay_assignment_actions paa
2843: ,per_all_assignments_f paf
2844: ,pay_payroll_actions ppa
2845: where paa.assignment_id = paf.assignment_id
2846: and paf.assignment_id = l_assignment_id
2847: and ppa.payroll_id = paf.payroll_id
2848: and ppa.payroll_action_id = paa.payroll_action_id