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_KW_PIFSS_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 34: ,pay_payroll_actions ppa

30: CURSOR csr_get_new_emp (l_employer_id number,l_effective_date date , l_nationality varchar2) IS
31: SELECT distinct asg.person_id
32: FROM per_assignments_f asg
33: ,pay_assignment_actions paa
34: ,pay_payroll_actions ppa
35: ,hr_soft_coding_keyflex hscl
36: ,per_periods_of_service pos
37: ,per_people_f pef
38: WHERE asg.assignment_id = paa.assignment_id

Line 87: ,pay_payroll_actions ppa

83: CURSOR csr_get_tot_emp (l_employer_id number,l_effective_date date , l_nationality varchar2) IS
84: SELECT distinct asg.person_id
85: FROM per_assignments_f asg
86: ,pay_assignment_actions paa
87: ,pay_payroll_actions ppa
88: ,hr_soft_coding_keyflex hscl
89: ,per_people_f pef
90: WHERE asg.assignment_id = paa.assignment_id
91: AND paa.payroll_action_id = ppa.payroll_action_id

Line 143: ,pay_payroll_actions ppa

139: CURSOR csr_get_change_emp(l_employer_id number, l_effective_date date , l_nationality varchar2) IS
140: SELECT distinct asg.person_id
141: FROM per_assignments_f asg
142: ,pay_assignment_actions paa
143: ,pay_payroll_actions ppa
144: ,hr_soft_coding_keyflex hscl
145: ,per_periods_of_service pos
146: ,per_people_f pef
147: WHERE asg.assignment_id = paa.assignment_id

Line 166: ,pay_payroll_actions ppa

162: --Cursor to get assignment_action_id of total employees
163: cursor get_assact_id_tot (p_org_id number,p_date date,p_person_id number , l_nationality varchar2) is
164: select paa.assignment_action_id from per_assignments_f asg
165: ,pay_assignment_actions paa
166: ,pay_payroll_actions ppa
167: ,hr_soft_coding_keyflex hscl
168: ,per_periods_of_service pos
169: ,per_people_f pef
170: where rownum < 2

Line 189: ,pay_payroll_actions ppa

185: --Cursor to get assignment_action_id of employees' previous month
186: cursor get_assact_id_tot_prev_month (p_org_id number,p_prev_month_date date,p_person_id number , l_nationality varchar2) is
187: select paa.assignment_action_id from per_assignments_f asg
188: ,pay_assignment_actions paa
189: ,pay_payroll_actions ppa
190: ,hr_soft_coding_keyflex hscl
191: ,per_periods_of_service pos
192: ,per_people_f pef
193: where rownum < 2

Line 280: ,pay_payroll_actions ppa

276: CURSOR csr_get_term_emp(l_employer_id number,l_effective_date date , l_nationality varchar2) IS
277: SELECT distinct asg.person_id
278: FROM per_assignments_f asg
279: ,pay_assignment_actions paa
280: ,pay_payroll_actions ppa
281: ,hr_soft_coding_keyflex hscl
282: ,per_periods_of_service pos
283: ,per_people_f pef
284: WHERE asg.assignment_id = paa.assignment_id

Line 367: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

363: p_parameter_string IN VARCHAR2
364: ,p_token IN VARCHAR2
365: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
366: IS
367: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
368: l_start_pos NUMBER;
369: l_delimiter varchar2(1);
370: BEGIN
371: l_delimiter :=' ';

Line 515: ,pay_payroll_actions ppa

511: CURSOR csr_get_first_assact_id (l_employer_id number, l_date date ,l_person_id number) IS
512: select paa.assignment_action_id
513: from per_assignments_f asg
514: ,pay_assignment_actions paa
515: ,pay_payroll_actions ppa
516: ,hr_soft_coding_keyflex hscl
517: ,per_periods_of_service pos
518: where rownum < 2
519: and asg.assignment_id = paa.assignment_id