DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 1176: update pay_retro_assignments

1172: -- with this date
1173: --
1174: if (l_ret_asg_id is not null) then
1175: --
1176: update pay_retro_assignments
1177: set reprocess_date = (select min(reprocess_date)
1178: from pay_retro_entries
1179: where retro_assignment_id = l_ret_asg_id),
1180: start_date = p_min_creation_date

Line 1296: from pay_retro_assignments

1292: begin
1293: --
1294: select start_date
1295: into l_start_date
1296: from pay_retro_assignments
1297: where assignment_id = p_assignment_id
1298: and retro_assignment_action_id is null
1299: and superseding_retro_asg_id is null;
1300: --