APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_PERIODS_OF_SERVICE

Line 1647: ,per_periods_of_service pos

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

Line 1677: ,per_periods_of_service pos

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

Line 1701: ,per_periods_of_service pos

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

Line 1723: ,per_periods_of_service pos

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