DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 1202: FROM JAI_OM_OE_BOND_REG_DTLS

1198: FROM JAI_OM_OE_BOND_REG_HDRS
1199: WHERE organization_id = p_organization_id
1200: AND location_id = p_location_id
1201: AND register_id IN (SELECT register_id
1202: FROM JAI_OM_OE_BOND_REG_DTLS
1203: WHERE order_type_id = p_batch_source_id
1204: AND order_flag = 'Y');
1205:
1206:

Line 1267: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS

1263: SELECT register_code
1264: FROM JAI_OM_OE_BOND_REG_HDRS
1265: WHERE organization_id = p_org_id AND
1266: location_id = p_loc_id AND
1267: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
1268: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
1269:
1270: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
1271: SELECT meaning