APPS.PAY_SLA_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

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

117: c_assignment_action_id,
118: c_payroll_action_id,
119: c_action_type,
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

Line 123: pay_assignment_actions pa1, -- cost assignment action

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

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

156: r_payroll_action_id,
157: r_action_type,
158: l_ledger_id,
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

Line 162: pay_assignment_actions pa2, -- run assignment action

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

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

665: ELSE
666:
667: SELECT pap.gl_set_of_books_id
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

Line 671: pay_assignment_actions pa1, -- cost assignment action

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

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

683: IF l_ledger_id is null then
684:
685: SELECT pap.gl_set_of_books_id
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

Line 689: pay_assignment_actions pa1, -- run assignment action

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