DBA Data[Home] [Help]

APPS.PAY_NL_REM_REPORT dependencies on PAY_ALL_PAYROLLS_F

Line 1009: ,pay_all_payrolls_f ppf

1005: ,paa.assignment_sequence assignment_sequence
1006: FROM pay_payroll_actions ppa
1007: ,pay_assignment_actions asg_act
1008: ,per_assignments_f paa
1009: ,pay_all_payrolls_f ppf
1010: ,per_periods_of_service pps
1011: ,hr_all_organization_units hou1
1012: ,per_all_people_f papf
1013: WHERE ppa.business_group_id = p_business_group_id

Line 1837: ,pay_all_payrolls_f ppf

1833: ,per_all_assignments_f paa
1834: ,per_periods_of_service pps
1835: ,pay_payroll_actions ppa
1836: ,pay_assignment_actions asg_act
1837: ,pay_all_payrolls_f ppf
1838: WHERE ppa.business_group_id = p_business_group_id
1839: AND nvl (paa.establishment_id
1840: ,ppf.prl_information1) = p_org_id
1841: AND papf.effective_start_date <= l_reporting_end_date

Line 1898: ,pay_all_payrolls_f ppf

1894: ,per_all_assignments_f paa
1895: ,per_periods_of_service pps
1896: ,pay_payroll_actions ppa
1897: ,pay_assignment_actions asg_act
1898: ,pay_all_payrolls_f ppf
1899: ,hr_all_organization_units hou1
1900: WHERE ppa.business_group_id = p_business_group_id
1901: AND papf.effective_start_date <= l_reporting_end_date
1902: AND papf.effective_end_date >= l_reporting_start_date