APPS.PAY_MIX_ROLLBACK_PKG dependencies on PER_ASSIGNMENTS_F

Line 234: l_assignment_id per_assignments_f.assignment_id%TYPE;

230: l_chk_entry_modified varchar2(1);
231: l_chk_rollback_upd varchar2(1);
232:
233: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
234: l_assignment_id per_assignments_f.assignment_id%TYPE;
235: l_request_id number := 0;
236: l_entry_exists varchar2(1) := 'N';
237:
238: begin

Line 348: from per_assignments_f asg

344: else
345:
346: select assignment_id
347: into l_assignment_id
348: from per_assignments_f asg
349: where upper(asg.assignment_number) = upper(l_batch_line.assignment_number)
350: and asg.business_group_id = l_business_group_id
351: and ((l_batch_line.effective_start_date is not null
352: and l_batch_line.effective_start_date between asg.effective_start_date