APPS.PAY_SLA_PKG dependencies on PAY_PAYROLL_ACTIONS

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

65: */
66: --
67: -- Caches for get_conversion_type
68: --
69: g_business_group_id pay_payroll_actions.business_group_id%TYPE := null;
70: g_currency_type gl_daily_rates.conversion_type%TYPE := null;
71: g_conversion_date date := null;
72: --
73: -- Caches for get_accounting_date

Line 101: r_action_type pay_payroll_actions.action_type%TYPE;

97: c_assignment_action_id NUMBER;
98: r_assignment_action_id NUMBER;
99: c_payroll_action_id NUMBER;
100: r_payroll_action_id NUMBER;
101: r_action_type pay_payroll_actions.action_type%TYPE;
102: r_assignment_id NUMBER;
103: c_action_type pay_payroll_actions.action_type%TYPE;
104: c_effective_date DATE;
105: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

Line 103: c_action_type pay_payroll_actions.action_type%TYPE;

99: c_payroll_action_id NUMBER;
100: r_payroll_action_id NUMBER;
101: r_action_type pay_payroll_actions.action_type%TYPE;
102: r_assignment_id NUMBER;
103: c_action_type pay_payroll_actions.action_type%TYPE;
104: c_effective_date DATE;
105: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
106: l_accounting_date DATE;
107: l_rev_accounting_date DATE;

Line 131: pay_payroll_actions ppa1 -- cost payroll action

127: c_effective_date
128: FROM pay_assignment_actions pa, -- TGL assignment action
129: pay_action_interlocks pi, -- interlock to cost
130: pay_assignment_actions pa1, -- cost assignment action
131: pay_payroll_actions ppa1 -- cost payroll action
132: WHERE pa.assignment_action_id = i_assignment_action_id
133: AND pi.locking_action_id = pa.assignment_action_id
134: AND pa1.assignment_action_id = pi.locked_action_id
135: AND ppa1.payroll_action_id = pa1.payroll_action_id

Line 170: pay_payroll_actions ppa2,-- run payroll action

166: l_accounting_date
167: FROM pay_assignment_actions pa, -- TGL assignment action
168: pay_action_interlocks pi2, -- interlock to run
169: pay_assignment_actions pa2, -- run assignment action
170: pay_payroll_actions ppa2,-- run payroll action
171: pay_all_payrolls_f pap
172: WHERE pa.assignment_action_id = i_assignment_action_id
173: AND pi2.locking_action_id = pa.assignment_action_id
174: AND pa2.assignment_action_id = pi2.locked_action_id

Line 683: pay_payroll_actions ppa1,-- cost payroll action

679: INTO l_ledger_id
680: FROM pay_assignment_actions pa, -- TGL assignment action
681: pay_action_interlocks pi, -- interlock to cost
682: pay_assignment_actions pa1, -- cost assignment action
683: pay_payroll_actions ppa1,-- cost payroll action
684: pay_all_payrolls_f pap
685: WHERE pa.assignment_action_id = i_assignment_action_id
686: AND pi.locking_action_id = pa.assignment_action_id
687: AND pa1.assignment_action_id = pi.locked_action_id

Line 703: pay_payroll_actions ppa1,-- run payroll action

699: INTO l_ledger_id
700: FROM pay_assignment_actions pa, -- TGL assignment action
701: pay_action_interlocks pi, -- interlock to run
702: pay_assignment_actions pa1, -- run assignment action
703: pay_payroll_actions ppa1,-- run payroll action
704: pay_all_payrolls_f pap,
705: per_all_assignments_f paf
706: WHERE pa.assignment_action_id = i_assignment_action_id
707: AND pi.locking_action_id = pa.assignment_action_id