DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 235: FROM JAI_OM_OE_BOND_REG_DTLS

231: FROM JAI_OM_OE_BOND_REG_HDRS
232: WHERE organization_id = p_org_id
233: AND location_id = p_loc_id
234: AND register_id IN (SELECT register_id
235: FROM JAI_OM_OE_BOND_REG_DTLS
236: WHERE order_type_id = p_batch_source_id
237: AND order_flag = 'N');
238:
239: CURSOR register_code_cur1(p_organization_id NUMBER,

Line 244: JAI_OM_OE_BOND_REG_DTLS b,

240: p_location_id NUMBER,
241: p_order_type varchar2) IS
242: SELECT A.register_code
243: FROM JAI_OM_OE_BOND_REG_HDRS A,
244: JAI_OM_OE_BOND_REG_DTLS b,
245: oe_transaction_types_tl ott
246: WHERE A.organization_id = p_organization_id
247: AND A.location_id = p_location_id
248: AND A.register_id = b.register_id