DBA Data[Home] [Help]

APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_ACTION_INTERLOCKS

Line 1088: from pay_action_interlocks pai,

1084: nvl(ye_asg.effective_start_date,ye_roll.START_YEAR)
1085: and ye_roll.END_YEAR
1086: and not exists(
1087: select '1'
1088: from pay_action_interlocks pai,
1089: pay_assignment_actions assact3,
1090: pay_payroll_actions pact3
1091: where pai.locked_action_id = assact2.assignment_action_id
1092: and pai.locking_action_id = assact3.assignment_action_id

Line 1258: from pay_action_interlocks pai,

1254: nvl(ye_asg.effective_start_date,ye_roll.START_PREVIOUS_YEAR)
1255: and ye_roll.END_PREVIOUS_YEAR
1256: and not exists(
1257: select '1'
1258: from pay_action_interlocks pai,
1259: pay_assignment_actions assact3,
1260: pay_payroll_actions pact3
1261: where pai.locked_action_id = assact2.assignment_action_id
1262: and pai.locking_action_id = assact3.assignment_action_id