DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 231: FROM JAI_OM_OE_BOND_REG_HDRS

227: CURSOR register_code_cur(p_org_id IN NUMBER,
228: p_loc_id IN NUMBER,
229: p_batch_source_id IN NUMBER) IS
230: SELECT register_code
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

Line 243: FROM JAI_OM_OE_BOND_REG_HDRS A,

239: CURSOR register_code_cur1(p_organization_id NUMBER,
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