APPS.PAY_SLA_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 128: FROM pay_assignment_actions pa, -- TGL assignment action

124: c_assignment_action_id,
125: c_payroll_action_id,
126: c_action_type,
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

Line 130: pay_assignment_actions pa1, -- cost assignment action

126: c_action_type,
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

Line 167: FROM pay_assignment_actions pa, -- TGL assignment action

163: r_payroll_action_id,
164: r_action_type,
165: l_ledger_id,
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

Line 169: pay_assignment_actions pa2, -- run assignment action

165: l_ledger_id,
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

Line 680: FROM pay_assignment_actions pa, -- TGL assignment action

676: ELSE
677:
678: SELECT pap.gl_set_of_books_id
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

Line 682: pay_assignment_actions pa1, -- cost assignment action

678: SELECT pap.gl_set_of_books_id
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

Line 700: FROM pay_assignment_actions pa, -- TGL assignment action

696: IF l_ledger_id is null then
697:
698: SELECT pap.gl_set_of_books_id
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,

Line 702: pay_assignment_actions pa1, -- run assignment action

698: SELECT pap.gl_set_of_books_id
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