291: /*Bug 5989740 bduvarag start*/
292: /* Commented for bug# 6459941
293: CURSOR c_get_rnd_factor (p_org_id IN NUMBER ) IS
294: SELECT NVL(tds_rounding_factor,0) , tds_rounding_start_date
295: FROM JAI_AP_TDS_YEARS
296: WHERE legal_entity_id IN (SELECT legal_entity_id
297: FROM hr_operating_units
298: where organization_id = p_org_id
299: )
305: SELECT
306: nvl(tds_rounding_factor,0) ,
307: tds_rounding_start_date
308: FROM
309: jai_ap_tds_years
310: WHERE
311: legal_entity_id = p_org_id
312: AND trunc (sysdate) between start_date and end_date ;
313: