APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 266: FROM JAI_OM_OE_BOND_REG_HDRS

262:
263: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER,
264: p_batch_source_id IN NUMBER) IS
265: SELECT register_code
266: FROM JAI_OM_OE_BOND_REG_HDRS
267: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
268: register_id IN (SELECT register_id
269: FROM JAI_OM_OE_BOND_REG_DTLS
270: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');

Line 280: FROM JAI_OM_OE_BOND_REG_HDRS A,

276: CURSOR register_code_cur1(p_organization_id NUMBER,
277: p_location_id NUMBER,
278: p_order_type varchar2) IS
279: SELECT A.register_code
280: FROM JAI_OM_OE_BOND_REG_HDRS A,
281: JAI_OM_OE_BOND_REG_DTLS b,
282: oe_transaction_types_tl ott
283: WHERE A.organization_id = p_organization_id
284: AND A.location_id = p_location_id

Line 1574: FROM JAI_OM_OE_BOND_REG_HDRS

1570: WHERE Customer_Trx_ID = v_customer_trx_id;
1571:
1572: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
1573: SELECT register_code
1574: FROM JAI_OM_OE_BOND_REG_HDRS
1575: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
1576: register_id IN (SELECT register_id
1577: FROM JAI_OM_OE_BOND_REG_DTLS
1578: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');