APPS.JAI_PA_TAX_PKG dependencies on PA_EXPENDITURE_TYPES

Line 714: lv_expenditure_type pa_expenditure_types.expenditure_type%type ;

710: ) is
711: ----------------variable declarations---------------------------
712: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
713: ln_count_expend_type number ;
714: lv_expenditure_type pa_expenditure_types.expenditure_type%type ;
715: ----------------cursor declarations------------------------------
716: -- count different types of expenditure defined in invoices lines
717: cursor cur_count_expend_type is
718: select count(distinct expenditure_type)

Line 740: cursor cur_expn_tax_category(cv_expenditure_type pa_expenditure_types.expenditure_type%type ) is

736: pdida.draft_invoice_item_line_num = pn_line_num
737: );
738:
739: -- find out tax category for expenditure types;
740: cursor cur_expn_tax_category(cv_expenditure_type pa_expenditure_types.expenditure_type%type ) is
741: select jpsv.setup_value1
742: from jai_pa_setup_values jpsv,
743: pa_expenditure_types pet
744: where jpsv.context = jai_constants.setup_expenditure_type and

Line 743: pa_expenditure_types pet

739: -- find out tax category for expenditure types;
740: cursor cur_expn_tax_category(cv_expenditure_type pa_expenditure_types.expenditure_type%type ) is
741: select jpsv.setup_value1
742: from jai_pa_setup_values jpsv,
743: pa_expenditure_types pet
744: where jpsv.context = jai_constants.setup_expenditure_type and
745: jpsv.attribute1 = pet.expenditure_type_id and
746: pet.expenditure_type =cv_expenditure_type ;
747: begin