DBA Data[Home] [Help]

APPS.PAY_KR_WF_SUBMIT_PROGRAM_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 33: pay_action_interlocks pai,

29: from pay_payroll_actions ppa,
30: pay_payroll_actions rppa,
31: pay_assignment_actions paa,
32: pay_assignment_actions rpaa,
33: pay_action_interlocks pai,
34: pay_run_types_f prt,
35: per_time_periods ptp
36: where ppa.payroll_action_id = p_run_type_period
37: and paa.payroll_action_id = ppa.payroll_action_id

Line 52: pay_action_interlocks pai_locking

48: and rppa.time_period_id = ptp.time_period_id
49: and ppa.payroll_action_id = paa.payroll_action_id
50: and rpaa.assignment_action_id = (select max(paa_locked.assignment_action_id)
51: from pay_assignment_actions paa_locked,
52: pay_action_interlocks pai_locking
53: where pai_locking.locking_action_id =
54: (select max(paa1.assignment_action_id)
55: from pay_assignment_actions paa1
56: where paa1.payroll_action_id = ppa.payroll_action_Id)