APPS.PAY_KR_PROCESS_NAV_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 221: pay_assignment_actions paa,

217: cursor csr_run_type_period_name is
218: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name
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

Line 222: pay_assignment_actions rpaa,

218: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name
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

Line 241: from pay_assignment_actions paa_locked,

237: and rpaa.run_type_id = prt.run_type_id
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

Line 245: from pay_assignment_actions paa1

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)
247: and paa_locked.assignment_action_id = pai_locking.locked_action_id)
248: and ppa.effective_date between prt.effective_start_date and prt.effective_end_date
249: and rppa.effective_date between ptp.start_date and ptp.end_date;