APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_AP_TDS_YEARS

Line 943: FROM JAI_AP_TDS_YEARS

939: /*Bug 5989740 bduvarag start*/
940: /* Commented for bug# 6459941
941: CURSOR c_get_rnd_factor (p_org_id IN NUMBER ) IS
942: SELECT NVL(tds_rounding_factor,0) , tds_rounding_start_date
943: FROM JAI_AP_TDS_YEARS
944: WHERE legal_entity_id IN (SELECT legal_entity_id
945: FROM hr_operating_units
946: where organization_id = p_org_id
947: )

Line 957: jai_ap_tds_years

953: SELECT
954: nvl(tds_rounding_factor,0) ,
955: tds_rounding_start_date
956: FROM
957: jai_ap_tds_years
958: WHERE
959: legal_entity_id = p_org_id
960: AND trunc (p_inv_date) between start_date and end_date ; -- Modified by Jia for FP Bug#8656402, change sysdate to p_inv_date
961: /*START, by amandali for Bug#10430662*/