DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 579: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;

575: /*Start of Addition*/
576: v_organization_id NUMBER;
577: v_location_id NUMBER;
578: v_batch_source_id NUMBER;
579: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%TYPE;
580:
581: CURSOR get_header_info_cur IS
582: SELECT organization_id, location_id, batch_source_id
583: FROM JAI_AR_TRXS

Line 588: FROM JAI_OM_OE_BOND_REG_HDRS

584: WHERE customer_trx_id = p_header_id;
585:
586: CURSOR get_register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_batch_source_id NUMBER) IS
587: SELECT register_code
588: FROM JAI_OM_OE_BOND_REG_HDRS
589: WHERE organization_id = p_organization_id
590: AND location_id = p_location_id
591: AND register_id IN (SELECT register_id
592: FROM JAI_OM_OE_BOND_REG_DTLS