APPS.PAY_KW_MONTHLY_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 414: ,pay_payroll_actions ppa

410: SELECT distinct asg.assignment_id
411: ,paa.assignment_action_id
412: FROM per_all_assignments_f asg /*per_assignments_f asg*/
413: ,pay_assignment_actions paa
414: ,pay_payroll_actions ppa
415: ,hr_soft_coding_keyflex hscl
416: ,per_all_people_f ppf /*per_people_f ppf*/
417: WHERE asg.assignment_id = paa.assignment_id
418: AND asg.person_id = ppf.person_id

Line 600: ,pay_payroll_actions ppa

596: ,paa.assignment_action_id
597: ,hscl.segment2
598: FROM per_assignments_f asg /*per_all_assignments_f asg*/
599: ,pay_assignment_actions paa
600: ,pay_payroll_actions ppa
601: ,hr_soft_coding_keyflex hscl
602: ,per_people_f ppf /*per_all_people_f ppf*/
603: WHERE asg.assignment_id = paa.assignment_id
604: AND asg.person_id = ppf.person_id

Line 1010: ,pay_payroll_actions ppa

1006: ,hscl.segment2
1007: ,asg.assignment_id
1008: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1009: ,pay_assignment_actions paa
1010: ,pay_payroll_actions ppa
1011: ,hr_soft_coding_keyflex hscl
1012: ,per_people_f ppf /*per_all_people_f ppf*/
1013: WHERE asg.assignment_id = paa.assignment_id
1014: AND asg.person_id = ppf.person_id

Line 1645: ,pay_payroll_actions ppa

1641: ,paa.assignment_action_id
1642: ,pos.date_start
1643: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1644: ,pay_assignment_actions paa
1645: ,pay_payroll_actions ppa
1646: ,hr_soft_coding_keyflex hscl
1647: ,per_periods_of_service pos
1648: ,per_people_f ppf /*per_all_people_f ppf*/
1649: WHERE asg.assignment_id = paa.assignment_id

Line 1675: ,pay_payroll_actions ppa

1671: ,pos.actual_termination_date
1672: ,ppa.date_earned
1673: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1674: ,pay_assignment_actions paa
1675: ,pay_payroll_actions ppa
1676: ,hr_soft_coding_keyflex hscl
1677: ,per_periods_of_service pos
1678: ,per_people_f ppf /*per_all_people_f ppf*/
1679: WHERE asg.assignment_id = paa.assignment_id

Line 1700: ,pay_payroll_actions ppa

1696: CURSOR csr_get_salary_date (p_person_id NUMBER) IS
1697: SELECT date_earned, paa.assignment_action_id
1698: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1699: ,pay_assignment_actions paa
1700: ,pay_payroll_actions ppa
1701: ,per_periods_of_service pos
1702: WHERE asg.assignment_id = paa.assignment_id
1703: AND paa.payroll_action_id = ppa.payroll_action_id
1704: AND pos.period_of_service_id = asg.period_of_service_id

Line 1721: ,pay_payroll_actions ppa

1717: ,paa.assignment_action_id
1718: ,date_earned
1719: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1720: ,pay_assignment_actions paa
1721: ,pay_payroll_actions ppa
1722: ,hr_soft_coding_keyflex hscl
1723: ,per_periods_of_service pos
1724: ,per_people_f ppf /*per_all_people_f ppf*/
1725: WHERE asg.assignment_id = paa.assignment_id