DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 1131: FROM JAI_OM_OE_BOND_REG_DTLS

1127: FROM JAI_OM_OE_BOND_REG_HDRS
1128: WHERE organization_id = p_organization_id
1129: AND location_id = p_location_id
1130: AND register_id IN (SELECT register_id
1131: FROM JAI_OM_OE_BOND_REG_DTLS
1132: WHERE order_type_id = p_batch_source_id
1133: AND order_flag = 'Y');
1134:
1135:

Line 1196: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS

1192: SELECT register_code
1193: FROM JAI_OM_OE_BOND_REG_HDRS
1194: WHERE organization_id = p_org_id AND
1195: location_id = p_loc_id AND
1196: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
1197: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
1198:
1199: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
1200: SELECT meaning