DBA Data[Home] [Help]

APPS.JAI_PA_BILLING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 550: FROM jai_rgm_org_regns_v

546: cp_location_id JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
547: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
548: ) IS
549: SELECT attribute_value
550: FROM jai_rgm_org_regns_v
551: WHERE regime_id = cp_regime_id
552: AND attribute_type_code = jai_constants.regn_type_others
553: AND attribute_code = jai_constants.attr_code_same_inv_no
554: AND organization_id = cp_organization_id

Line 558: lv_same_invoice_no_flag jai_rgm_org_regns_v.attribute_value%type;

554: AND organization_id = cp_organization_id
555: AND location_id = cp_location_id;
556:
557: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
558: lv_same_invoice_no_flag jai_rgm_org_regns_v.attribute_value%type;
559: lv_vat_invoice_no VARCHAR2(240);
560: ld_vat_invoice_date DATE;
561:
562: r_draft_invoice_dtls c_draft_invoice_dtls%ROWTYPE;