APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 131: FROM JAI_OM_OE_BOND_REG_HDRS

127: WHERE Customer_Trx_ID = v_customer_trx_id;
128: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER,
129: p_batch_source_id IN NUMBER) IS
130: SELECT register_code
131: FROM JAI_OM_OE_BOND_REG_HDRS
132: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
133: register_id IN (SELECT register_id
134: FROM JAI_OM_OE_BOND_REG_DTLS
135: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');

Line 145: FROM JAI_OM_OE_BOND_REG_HDRS A,

141: CURSOR register_code_cur1(p_organization_id NUMBER,
142: p_location_id NUMBER,
143: p_order_type varchar2) IS
144: SELECT A.register_code
145: FROM JAI_OM_OE_BOND_REG_HDRS A,
146: JAI_OM_OE_BOND_REG_DTLS b,
147: oe_transaction_types_tl ott
148: WHERE A.organization_id = p_organization_id
149: AND A.location_id = p_location_id

Line 977: FROM JAI_OM_OE_BOND_REG_HDRS

973: WHERE Customer_Trx_ID = v_customer_trx_id;
974:
975: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
976: SELECT register_code
977: FROM JAI_OM_OE_BOND_REG_HDRS
978: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
979: register_id IN (SELECT register_id
980: FROM JAI_OM_OE_BOND_REG_DTLS
981: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');