2323: AND hcl.lookup_code(+) = hrw.fcl_earn_reason_code
2324:
2325: --END GLOBAL
2326: AND hrw.pay_status = 'C'
2327: AND hrw.effective_end_date < hr_general.end_of_time; --SIR149 --FORMS60
2328:
2329:
2330: --BSE128 l_leftover leftover_hours %ROWTYPE;
2331: -- l_nextval NUMBER (15);
2798: AND hcl.lookup_code(+) = hrw.fcl_earn_reason_code
2799:
2800: --END GLOBAL
2801: AND hrw.pay_status = 'C'
2802: AND hrw.effective_end_date < hr_general.end_of_time; --SIR149 --FORMS60
2803:
2804: l_leftover leftover_amount%ROWTYPE;
2805: -- l_nextval NUMBER (15);
2806: l_batch_line_id NUMBER (15);