73: p_division_no OUT NOCOPY varchar2) IS
74: BEGIN
75: For hr_rec IN (SELECT excise_duty_range range,
76: excise_duty_division div
77: FROM JAI_CMN_VENDOR_SITES
78: WHERE vendor_id = p_vendor_id
79: AND vendor_site_id = p_vendor_site_id)
80: LOOP
81: p_range_no := hr_rec.range;