APPS.JAI_PA_BILLING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 515: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type

511:
512: CURSOR c_same_inv_no(
513: cp_organization_id JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
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

Line 525: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

521: AND attribute_code = jai_constants.attr_code_same_inv_no
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:

Line 1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;

1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1522: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1523: ln_lines_to_insert number;
1524: ln_nrec_tax_amt number;
1525: ln_rec_tax_amt number;

Line 1651: cursor c_get_regime_id (cpv_regime_code JAI_RGM_DEFINITIONS.regime_code%type)

1647: where tax_id = cpn_tax_id;
1648:
1649: r_tax_details c_tax_details%rowtype ;
1650:
1651: cursor c_get_regime_id (cpv_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
1652: is
1653: select regime_id
1654: from JAI_RGM_DEFINITIONS
1655: where regime_code = cpv_regime_code;

Line 1654: from JAI_RGM_DEFINITIONS

1650:
1651: cursor c_get_regime_id (cpv_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
1652: is
1653: select regime_id
1654: from JAI_RGM_DEFINITIONS
1655: where regime_code = cpv_regime_code;
1656:
1657: cursor c_get_rgm_for_tax_type (cpv_tax_type varchar2)
1658: is