DBA Data[Home] [Help]

APPS.PAY_SA_HIST_ARCH_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 129: pay_action_interlocks lck,

125: ppa.effective_date
126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null
133: and paaf.person_id between stperson and endperson

Line 236: FROM pay_action_interlocks archive_intlck

232: CURSOR get_run_action_det (p_locking_action_id NUMBER) IS
233: SELECT run_assact.assignment_id run_assgt_id
234: ,run_assact.assignment_action_id run_assact_id
235: ,prepay_payact.effective_date prepay_effective_date
236: FROM pay_action_interlocks archive_intlck
237: ,pay_assignment_actions prepay_assact
238: ,pay_payroll_actions prepay_payact
239: ,pay_action_interlocks prepay_intlck
240: ,pay_assignment_actions run_assact

Line 239: ,pay_action_interlocks prepay_intlck

235: ,prepay_payact.effective_date prepay_effective_date
236: FROM pay_action_interlocks archive_intlck
237: ,pay_assignment_actions prepay_assact
238: ,pay_payroll_actions prepay_payact
239: ,pay_action_interlocks prepay_intlck
240: ,pay_assignment_actions run_assact
241: ,pay_payroll_actions run_payact
242: WHERE archive_intlck.locking_action_id = p_locking_action_id
243: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id