APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 269: FROM JAI_OM_OE_BOND_REG_DTLS

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');
271:
272: /* Bug 4938350. Added by Lakshmi Gopalsami
273: Removed the sub-query and added oe_transaction_types_tl

Line 281: JAI_OM_OE_BOND_REG_DTLS b,

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
285: AND A.register_id = b.register_id

Line 1577: FROM JAI_OM_OE_BOND_REG_DTLS

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');
1579:
1580: /* Bug 5243532. Added by Lakshmi Gopalsami
1581: * Removed cursor set_of_books_cur and c_opr_set_of_books_id