DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on PAY_RETRO_ASSIGNMENTS

Line 1111: update pay_retro_assignments

1107: -- with this date
1108: --
1109: if (l_ret_asg_id is not null) then
1110: --
1111: update pay_retro_assignments
1112: set reprocess_date = (select min(reprocess_date)
1113: from pay_retro_entries
1114: where retro_assignment_id = l_ret_asg_id),
1115: start_date = p_min_creation_date

Line 1231: from pay_retro_assignments

1227: begin
1228: --
1229: select start_date
1230: into l_start_date
1231: from pay_retro_assignments
1232: where assignment_id = p_assignment_id
1233: and retro_assignment_action_id is null
1234: and superseding_retro_asg_id is null;
1235: --