APPS.PAY_SLA_UPDATE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 54: FROM Pay_All_Payrolls_f pp

50: AND Application_Id = '101'
51: AND Period_Name = p_End_Period)
52: OR p_End_Period is null)
53: AND EXISTS (SELECT 1
54: FROM Pay_All_Payrolls_f pp
55: WHERE pp.gl_Set_Of_Books_Id IS NOT NULL
56: AND gps.Ledger_Id = pp.gl_Set_Of_Books_Id)
57: ORDER BY gps.Start_Date;
58:

Line 1026: pay_all_payrolls_f pp,

1022: FROM pay_payroll_actions ppa1, -- Cost pay actions
1023: pay_assignment_actions pa1, -- Cost asg actions.
1024: pay_action_interlocks pi3, -- Cost - Run
1025: pay_action_interlocks pi1, -- Cost - Trans GL
1026: pay_all_payrolls_f pp,
1027: pay_action_classifications pac,
1028: pay_payroll_actions ppa2, -- Payroll run actions.
1029: pay_assignment_actions pa2, -- Payroll run asg actions.
1030: pay_action_interlocks pi2, -- Run - Trans GL

Line 1093: pay_all_payrolls_f pp,

1089: pay_action_interlocks pi1, -- Cost - Trans GL
1090: pay_assignment_actions pa1, -- Cost asg actions
1091: pay_payroll_actions ppa1, -- Cost pay actions
1092: per_all_assignments_f pera,
1093: pay_all_payrolls_f pp,
1094: pay_payment_costs_v ppc,
1095: gl_je_headers gjh,
1096: gl_je_lines gjl
1097: WHERE ppa.payroll_action_id = to_number(gjl.reference_1)