APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_PERIODS_OF_SERVICE

Line 1805: ,per_periods_of_service pos

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
1808: AND asg.person_id = ppf.person_id
1809: AND ppf.nationality = l_local_nationality

Line 1835: ,per_periods_of_service pos

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
1838: AND asg.person_id = ppf.person_id
1839: AND ppf.nationality = l_local_nationality

Line 1859: ,per_periods_of_service pos

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
1863: AND ppa.action_type in ('R','Q')

Line 1882: ,per_periods_of_service pos

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
1885: AND asg.person_id = ppf.person_id
1886: AND ppf.nationality = l_local_nationality