DBA Data[Home] [Help]

APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 223: pay_action_interlocks pai,

219: from pay_payroll_actions ppa,
220: pay_payroll_actions rppa,
221: pay_assignment_actions paa,
222: pay_assignment_actions rpaa,
223: pay_action_interlocks pai,
224: pay_run_types_f prt,
225: per_time_periods ptp
226: where ppa.payroll_action_id = p_run_type_period
227: and paa.payroll_action_id = ppa.payroll_action_id

Line 242: pay_action_interlocks pai_locking

238: and rppa.time_period_id = ptp.time_period_id
239: and ppa.payroll_action_id = paa.payroll_action_id
240: and rpaa.assignment_action_id = (select max(paa_locked.assignment_action_id)
241: from pay_assignment_actions paa_locked,
242: pay_action_interlocks pai_locking
243: where pai_locking.locking_action_id =
244: (select max(paa1.assignment_action_id)
245: from pay_assignment_actions paa1
246: where paa1.payroll_action_id = ppa.payroll_action_Id)