DBA Data[Home] [Help]

APPS.PAY_FR_DADS_EMP_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 1158: from pay_action_interlocks pai

1154: -- as part of Time Analysis Changes.
1155: Cursor csr_get_per_dates(p_effective_date DATE) Is
1156: select ptp.end_date
1157: ,ptp.start_date
1158: from pay_action_interlocks pai
1159: , pay_assignment_actions paa
1160: , pay_payroll_actions ppa
1161: , per_time_periods ptp
1162: where pai.locking_action_id = g_assign_action_id

Line 3943: , pay_action_interlocks RINTLK

3939: and NOT EXISTS
3940: (SELECT NULL
3941: FROM pay_payroll_actions RPACT
3942: , pay_assignment_actions RASSACT
3943: , pay_action_interlocks RINTLK
3944: where paa.assignment_action_id = RINTLK.locked_action_id
3945: and RINTLK.locking_action_id = RASSACT.assignment_action_id
3946: and RPACT.payroll_action_id = RASSACT.payroll_action_id
3947: and RPACT.action_type = 'V')