DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 527: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;

523: /*Start of Addition*/
524: v_organization_id NUMBER;
525: v_location_id NUMBER;
526: v_batch_source_id NUMBER;
527: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;
528:
529: CURSOR get_header_info_cur IS
530: SELECT organization_id, location_id, batch_source_id
531: FROM JAI_AR_TRXS

Line 536: FROM JAI_OM_OE_BOND_REG_HDRS

532: WHERE customer_trx_id = p_header_id;
533:
534: CURSOR get_register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_batch_source_id NUMBER) IS
535: SELECT register_code
536: FROM JAI_OM_OE_BOND_REG_HDRS
537: WHERE organization_id = p_organization_id
538: AND location_id = p_location_id
539: AND register_id IN (SELECT register_id
540: FROM JAI_OM_OE_BOND_REG_DTLS