2029:
2030: if l_start_date is not null and l_end_date is not null then
2031: hr_utility.trace('test3');
2032: select
2033: pay_advance_pay_pkg.advanced_periods(
2034: p_person_rec.assignment_id,
2035: l_start_date,
2036: l_end_date
2037: ) into l_periods_covered from dual;
2866:
2867: if l_start_date is not null and l_end_date is not null then
2868: hr_utility.trace('test3');
2869: select
2870: pay_advance_pay_pkg.advanced_periods(
2871: p_person_rec.assignment_id,
2872: l_start_date,
2873: l_end_date
2874: ) into l_periods_covered from dual;
3653:
3654: if l_start_date is not null and l_end_date is not null then
3655: hr_utility.trace('test3');
3656: select
3657: pay_advance_pay_pkg.advanced_periods(
3658: l_asg_id,
3659: l_start_date,
3660: l_end_date
3661: ) into l_periods_covered from dual;