APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 672: FROM JAI_OM_OE_BOND_REG_DTLS

668: SELECT register_code
669: FROM JAI_OM_OE_BOND_REG_HDRS
670: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
671: register_id IN (SELECT register_id
672: FROM JAI_OM_OE_BOND_REG_DTLS
673: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N');
674:
675: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
676: SELECT MAX(A.fin_year)