DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on PAY_ALL_PAYROLLS_F

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

238: --to fetch the payroll name
239: BEGIN
240: SELECT ppf.payroll_name INTO l_payroll_name
241: FROM
242: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458
243: --pay_payrolls_f ppf
244: pay_all_payrolls_f ppf
245: WHERE ppf.payroll_id=l_payroll_id;
246: EXCEPTION

Line 244: pay_all_payrolls_f ppf

240: SELECT ppf.payroll_name INTO l_payroll_name
241: FROM
242: -- Replaced view pay_payrolls_f with table pay_all_payrolls_f for bug fix 5231458
243: --pay_payrolls_f ppf
244: pay_all_payrolls_f ppf
245: WHERE ppf.payroll_id=l_payroll_id;
246: EXCEPTION
247: WHEN OTHERS THEN
248: NULL;

Line 361: ,pay_all_payrolls_f ppf

357: ,paa1.assignment_action_id) balance_amount
358: FROM
359: hr_assignment_set_amendments hasa
360: ,per_all_assignments_f paaf
361: ,pay_all_payrolls_f ppf
362: ,pay_assignment_actions paa1
363: ,pay_assignment_actions paa2
364: ,pay_payroll_actions ppa1
365: ,pay_payroll_actions ppa2

Line 474: ,pay_all_payrolls_f ppf

470:
471: FROM
472: -- hr_assignment_set_amendments hasa
473: per_all_assignments_f paaf
474: ,pay_all_payrolls_f ppf
475: ,pay_assignment_actions paa1
476: ,pay_assignment_actions paa2
477: ,pay_payroll_actions ppa1
478: ,pay_payroll_actions ppa2