268:
269: BEGIN
270: l_check := 'X';
271: xml_ctr := 0;
272: l_start_date :=FND_DATE.CANONICAL_TO_DATE(p_start_date);
273: l_end_date :=FND_DATE.CANONICAL_TO_DATE(p_end_date);
274:
275: FOR asg_rec IN csr_asg LOOP
276:
269: BEGIN
270: l_check := 'X';
271: xml_ctr := 0;
272: l_start_date :=FND_DATE.CANONICAL_TO_DATE(p_start_date);
273: l_end_date :=FND_DATE.CANONICAL_TO_DATE(p_end_date);
274:
275: FOR asg_rec IN csr_asg LOOP
276:
277: OPEN csr_payroll_start_date(asg_rec.payroll_id,asg_rec.absence_start_date);