APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 134: FROM JAI_OM_OE_BOND_REG_DTLS

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

Line 146: JAI_OM_OE_BOND_REG_DTLS b,

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

Line 980: FROM JAI_OM_OE_BOND_REG_DTLS

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