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
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;
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
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