DBA Data[Home] [Help]

APPS.PAY_ZA_EMP201 dependencies on PAY_ALL_PAYROLLS_F

Line 283: from pay_all_payrolls_f

279: -- payroll name no longer required
280: /*
281: CURSOR get_payroll_name (p_payroll_id number, l_effective_date date)IS
282: select payroll_name
283: from pay_all_payrolls_f
284: where payroll_id = p_payroll_id
285: and l_effective_date between effective_start_date and effective_end_date;
286: */
287: CURSOR get_legal_entity_name(p_organization_id number)IS

Line 1442: , pay_all_payrolls_f ppf

1438: pai.effective_date effective_date
1439: from pay_payroll_actions ppa
1440: , pay_assignment_actions paa
1441: , pay_action_information pai
1442: , pay_all_payrolls_f ppf
1443: where ppa.payroll_action_id = pactid
1444: and ppa.action_status = 'C'
1445: and paa.payroll_action_id = ppa.payroll_action_id
1446: and paa.action_status = 'C'