APPS.JAI_PA_BILLING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 518: FROM jai_rgm_org_regns_v

514: cp_location_id JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
515: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
516: ) IS
517: SELECT attribute_value
518: FROM jai_rgm_org_regns_v
519: WHERE regime_id = cp_regime_id
520: AND attribute_type_code = jai_constants.regn_type_others
521: AND attribute_code = jai_constants.attr_code_same_inv_no
522: AND organization_id = cp_organization_id

Line 526: lv_same_invoice_no_flag jai_rgm_org_regns_v.attribute_value%type;

522: AND organization_id = cp_organization_id
523: AND location_id = cp_location_id;
524:
525: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
526: lv_same_invoice_no_flag jai_rgm_org_regns_v.attribute_value%type;
527: lv_vat_invoice_no VARCHAR2(240);
528: ld_vat_invoice_date DATE;
529:
530: r_draft_invoice_dtls c_draft_invoice_dtls%ROWTYPE;