3331: l_adr_primary per_addresses.primary_flag%TYPE;
3332: l_adr_style per_addresses.style%TYPE;
3333: -- <<
3334: l_exit_quietly exception;
3335: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3336: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3337: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3338: --
3339: -- rmonge Bug fix 3599825.
3332: l_adr_style per_addresses.style%TYPE;
3333: -- <<
3334: l_exit_quietly exception;
3335: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3336: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3337: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3338: --
3339: -- rmonge Bug fix 3599825.
3340:
3333: -- <<
3334: l_exit_quietly exception;
3335: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3336: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3337: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3338: --
3339: -- rmonge Bug fix 3599825.
3340:
3341: cursor csr_asg_id(p_csr_assignment_id number) is
3371: as link to all payrolls and trying to remove payroll after defaulting*/
3372:
3373: cursor csr_defaultpayrollremoved(p_assignment_id number,p_effective_date date) is
3374: select null
3375: from per_all_assignments_f paa,
3376: pay_element_links_f pel,
3377: pay_element_types_f pet
3378: where paa.assignment_id=p_assignment_id
3379: and paa.payroll_id is null
3393: cursor csr_asgmt_details(p_assignment_id number,p_effective_date date) is
3394: select payroll_id,
3395: effective_start_date,
3396: effective_end_date
3397: from per_all_assignments_f
3398: where assignment_id=p_assignment_id
3399: and p_effective_date between effective_start_date
3400: and effective_end_date;
3401: