APPS.PAY_KW_MONTHLY_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 482: ,pay_payroll_actions ppa

478: SELECT distinct asg.assignment_id
479: ,paa.assignment_action_id
480: FROM per_all_assignments_f asg /*per_assignments_f asg*/
481: ,pay_assignment_actions paa
482: ,pay_payroll_actions ppa
483: ,hr_soft_coding_keyflex hscl
484: ,per_all_people_f ppf /*per_people_f ppf*/
485: WHERE asg.assignment_id = paa.assignment_id
486: AND asg.person_id = ppf.person_id

Line 751: ,pay_payroll_actions ppa

747: ,paa.assignment_action_id
748: ,hscl.segment2
749: FROM per_assignments_f asg /*per_all_assignments_f asg*/
750: ,pay_assignment_actions paa
751: ,pay_payroll_actions ppa
752: ,hr_soft_coding_keyflex hscl
753: ,per_people_f ppf /*per_all_people_f ppf*/
754: WHERE asg.assignment_id = paa.assignment_id
755: AND asg.person_id = ppf.person_id

Line 1161: ,pay_payroll_actions ppa

1157: ,hscl.segment2
1158: ,asg.assignment_id
1159: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1160: ,pay_assignment_actions paa
1161: ,pay_payroll_actions ppa
1162: ,hr_soft_coding_keyflex hscl
1163: ,per_people_f ppf /*per_all_people_f ppf*/
1164: WHERE asg.assignment_id = paa.assignment_id
1165: AND asg.person_id = ppf.person_id

Line 1803: ,pay_payroll_actions ppa

1799: ,paa.assignment_action_id
1800: ,pos.date_start
1801: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1802: ,pay_assignment_actions paa
1803: ,pay_payroll_actions ppa
1804: ,hr_soft_coding_keyflex hscl
1805: ,per_periods_of_service pos
1806: ,per_people_f ppf /*per_all_people_f ppf*/
1807: WHERE asg.assignment_id = paa.assignment_id

Line 1833: ,pay_payroll_actions ppa

1829: ,pos.actual_termination_date
1830: ,ppa.date_earned
1831: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1832: ,pay_assignment_actions paa
1833: ,pay_payroll_actions ppa
1834: ,hr_soft_coding_keyflex hscl
1835: ,per_periods_of_service pos
1836: ,per_people_f ppf /*per_all_people_f ppf*/
1837: WHERE asg.assignment_id = paa.assignment_id

Line 1858: ,pay_payroll_actions ppa

1854: CURSOR csr_get_salary_date (p_person_id NUMBER) IS
1855: SELECT date_earned, paa.assignment_action_id
1856: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1857: ,pay_assignment_actions paa
1858: ,pay_payroll_actions ppa
1859: ,per_periods_of_service pos
1860: WHERE asg.assignment_id = paa.assignment_id
1861: AND paa.payroll_action_id = ppa.payroll_action_id
1862: AND pos.period_of_service_id = asg.period_of_service_id

Line 1880: ,pay_payroll_actions ppa

1876: ,paa.assignment_action_id
1877: ,date_earned
1878: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1879: ,pay_assignment_actions paa
1880: ,pay_payroll_actions ppa
1881: ,hr_soft_coding_keyflex hscl
1882: ,per_periods_of_service pos
1883: ,per_people_f ppf /*per_all_people_f ppf*/
1884: WHERE asg.assignment_id = paa.assignment_id

Line 1929: from pay_payroll_actions ppa, pay_assignment_actions paa

1925:
1926: /* Cursor to fetch assignment_action_id corresponding to first_date_earned to calculate social allowance Oct 2012*/
1927: CURSOR csr_get_assact_one (l_assignment_id number,l_date date) IS
1928: select paa.assignment_action_id
1929: from pay_payroll_actions ppa, pay_assignment_actions paa
1930: Where paa.assignment_id = l_assignment_id
1931: and paa.payroll_action_id = ppa.payroll_action_id
1932: and ppa.action_type in ('R','Q')
1933: and ppa.action_status = 'C'

Line 1945: ,pay_payroll_actions ppa

1941: ,asg.assignment_id
1942: ,paa.assignment_action_id
1943: FROM per_assignments_f asg
1944: ,pay_assignment_actions paa
1945: ,pay_payroll_actions ppa
1946: ,hr_soft_coding_keyflex hscl
1947: ,per_people_f ppf
1948: WHERE asg.assignment_id = paa.assignment_id
1949: AND paa.payroll_action_id = ppa.payroll_action_id