APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 3194: AND register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS

3190: SELECT register_code
3191: FROM JAI_OM_OE_BOND_REG_HDRS
3192: WHERE organization_id = p_org_id
3193: AND location_id = p_loc_id
3194: AND register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
3195: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
3196:
3197: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
3198: SELECT pref_rg23a, pref_rg23c, pref_pla

Line 4426: FROM JAI_OM_OE_BOND_REG_DTLS

4422: FROM JAI_OM_OE_BOND_REG_HDRS
4423: WHERE organization_id = p_organization_id
4424: AND location_id = p_location_id
4425: AND register_id IN (SELECT register_id
4426: FROM JAI_OM_OE_BOND_REG_DTLS
4427: WHERE order_type_id = p_batch_source_id
4428: AND order_flag = 'Y');
4429:
4430: v_pref_rg23a NUMBER;