DBA Data[Home] [Help]

APPS.PAY_DK_PR_ELE dependencies on PAY_ALL_PAYROLLS_F

Line 205: ,pay_all_payrolls_f ppf

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

Line 283: ,pay_all_payrolls_f ppf

279: (pivf.input_value_id,'_ASG_YTD'),
280: paa1.assignment_action_id) balance_amount*/
281: FROM
282: per_all_assignments_f paaf
283: ,pay_all_payrolls_f ppf
284: ,pay_assignment_actions paa1
285: ,pay_assignment_actions paa2
286: ,pay_payroll_actions ppa1
287: ,pay_payroll_actions ppa2

Line 375: ,pay_all_payrolls_f ppf

371: FROM
372:
373: per_all_assignments_f paaf
374: ,pay_element_set_members pesm
375: ,pay_all_payrolls_f ppf
376: ,pay_assignment_actions paa1
377: ,pay_assignment_actions paa2
378: ,pay_payroll_actions ppa1
379: ,pay_payroll_actions ppa2

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

493: --to fetch the payroll name
494: BEGIN
495: SELECT ppf.payroll_name INTO l_payroll_name
496: FROM
497: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458
498: --pay_payrolls_f ppf
499: pay_all_payrolls_f ppf
500: WHERE ppf.payroll_id=l_payroll_id;
501: EXCEPTION

Line 499: pay_all_payrolls_f ppf

495: SELECT ppf.payroll_name INTO l_payroll_name
496: FROM
497: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458
498: --pay_payrolls_f ppf
499: pay_all_payrolls_f ppf
500: WHERE ppf.payroll_id=l_payroll_id;
501: EXCEPTION
502: WHEN OTHERS THEN
503: NULL;