DBA Data[Home] [Help]

APPS.PAY_DK_PR_LE dependencies on PAY_ALL_PAYROLLS_F

Line 208: ,pay_all_payrolls_f ppf

204: (pivf.input_value_id,'_ASG_RUN')
205: ,paa1.assignment_action_id)) ele_ytd
206: FROM
207: per_all_assignments_f paaf
208: ,pay_all_payrolls_f ppf
209: ,pay_assignment_actions paa1
210: ,pay_assignment_actions paa2
211: ,pay_payroll_actions ppa1
212: ,pay_payroll_actions ppa2

Line 301: ,pay_all_payrolls_f ppf

297: ,pay_assignment_actions paa2
298: ,pay_run_results prr
299: ,pay_input_values_f pivf
300: ,pay_element_types_f petf
301: ,pay_all_payrolls_f ppf
302: ,pay_payroll_actions ppa1
303: ,pay_payroll_actions ppa2
304: ,hr_all_organization_units haou1
305: ,hr_all_organization_units haou2

Line 409: ,pay_all_payrolls_f ppf

405: ,pay_assignment_actions paa2
406: ,pay_run_results prr
407: ,pay_input_values_f pivf
408: ,pay_element_types_f petf
409: ,pay_all_payrolls_f ppf
410: ,pay_payroll_actions ppa1
411: ,pay_payroll_actions ppa2
412: ,pay_element_set_members pesm
413: ,hr_all_organization_units haou1

Line 534: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458

530: --to fetch the payroll name
531: BEGIN
532: SELECT ppf.payroll_name INTO l_payroll_name
533: FROM
534: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458
535: --pay_payrolls_f ppf
536: pay_all_payrolls_f ppf
537: WHERE ppf.payroll_id=l_payroll_id;
538: EXCEPTION

Line 536: pay_all_payrolls_f ppf

532: SELECT ppf.payroll_name INTO l_payroll_name
533: FROM
534: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458
535: --pay_payrolls_f ppf
536: pay_all_payrolls_f ppf
537: WHERE ppf.payroll_id=l_payroll_id;
538: EXCEPTION
539: WHEN OTHERS THEN
540: NULL;