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 1023: pay_all_payrolls_f pp,

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

Line 1090: pay_all_payrolls_f pp,

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