APPS.PAY_SLA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 62: g_business_group_id pay_payroll_actions.business_group_id%TYPE := null;

58: */
59: --
60: -- Caches for get_conversion_type
61: --
62: g_business_group_id pay_payroll_actions.business_group_id%TYPE := null;
63: g_currency_type gl_daily_rates.conversion_type%TYPE := null;
64: g_conversion_date date := null;
65: --
66: -- Caches for get_accounting_date

Line 94: r_action_type pay_payroll_actions.action_type%TYPE;

90: c_assignment_action_id NUMBER;
91: r_assignment_action_id NUMBER;
92: c_payroll_action_id NUMBER;
93: r_payroll_action_id NUMBER;
94: r_action_type pay_payroll_actions.action_type%TYPE;
95: r_assignment_id NUMBER;
96: c_action_type pay_payroll_actions.action_type%TYPE;
97: c_effective_date DATE;
98: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

Line 96: c_action_type pay_payroll_actions.action_type%TYPE;

92: c_payroll_action_id NUMBER;
93: r_payroll_action_id NUMBER;
94: r_action_type pay_payroll_actions.action_type%TYPE;
95: r_assignment_id NUMBER;
96: c_action_type pay_payroll_actions.action_type%TYPE;
97: c_effective_date DATE;
98: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
99: l_accounting_date DATE;
100: l_rev_accounting_date DATE;

Line 124: pay_payroll_actions ppa1 -- cost payroll action

120: c_effective_date
121: FROM pay_assignment_actions pa, -- TGL assignment action
122: pay_action_interlocks pi, -- interlock to cost
123: pay_assignment_actions pa1, -- cost assignment action
124: pay_payroll_actions ppa1 -- cost payroll action
125: WHERE pa.assignment_action_id = i_assignment_action_id
126: AND pi.locking_action_id = pa.assignment_action_id
127: AND pa1.assignment_action_id = pi.locked_action_id
128: AND ppa1.payroll_action_id = pa1.payroll_action_id

Line 163: pay_payroll_actions ppa2,-- run payroll action

159: l_accounting_date
160: FROM pay_assignment_actions pa, -- TGL assignment action
161: pay_action_interlocks pi2, -- interlock to run
162: pay_assignment_actions pa2, -- run assignment action
163: pay_payroll_actions ppa2,-- run payroll action
164: pay_all_payrolls_f pap
165: WHERE pa.assignment_action_id = i_assignment_action_id
166: AND pi2.locking_action_id = pa.assignment_action_id
167: AND pa2.assignment_action_id = pi2.locked_action_id

Line 672: pay_payroll_actions ppa1,-- cost payroll action

668: INTO l_ledger_id
669: FROM pay_assignment_actions pa, -- TGL assignment action
670: pay_action_interlocks pi, -- interlock to cost
671: pay_assignment_actions pa1, -- cost assignment action
672: pay_payroll_actions ppa1,-- cost payroll action
673: pay_all_payrolls_f pap
674: WHERE pa.assignment_action_id = i_assignment_action_id
675: AND pi.locking_action_id = pa.assignment_action_id
676: AND pa1.assignment_action_id = pi.locked_action_id

Line 690: pay_payroll_actions ppa1,-- run payroll action

686: INTO l_ledger_id
687: FROM pay_assignment_actions pa, -- TGL assignment action
688: pay_action_interlocks pi, -- interlock to run
689: pay_assignment_actions pa1, -- run assignment action
690: pay_payroll_actions ppa1,-- run payroll action
691: pay_all_payrolls_f pap
692: WHERE pa.assignment_action_id = i_assignment_action_id
693: AND pi.locking_action_id = pa.assignment_action_id
694: AND pa1.assignment_action_id = pi.locked_action_id