DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_AP_TDS_YEARS

Line 295: FROM JAI_AP_TDS_YEARS

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: )

Line 309: jai_ap_tds_years

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: