APPS.JAI_PA_TAX_PKG dependencies on PA_EXPENDITURE_TYPES

Line 747: lv_expenditure_type pa_expenditure_types.expenditure_type%type ;

743: ) is
744: ----------------variable declarations---------------------------
745: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type;
746: ln_count_expend_type number ;
747: lv_expenditure_type pa_expenditure_types.expenditure_type%type ;
748: ln_org_id NUMBER; /*Bug 8348822*/
749: ----------------cursor declarations------------------------------
750: -- count different types of expenditure defined in invoices lines
751: cursor cur_count_expend_type is

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

770: pdida.draft_invoice_item_line_num = pn_line_num
771: );
772:
773: -- find out tax category for expenditure types;
774: cursor cur_expn_tax_category(cv_expenditure_type pa_expenditure_types.expenditure_type%type ) is
775: select jpsv.setup_value1
776: from jai_pa_setup_values jpsv,
777: pa_expenditure_types pet
778: where jpsv.context = jai_constants.setup_expenditure_type and

Line 777: pa_expenditure_types pet

773: -- find out tax category for expenditure types;
774: cursor cur_expn_tax_category(cv_expenditure_type pa_expenditure_types.expenditure_type%type ) is
775: select jpsv.setup_value1
776: from jai_pa_setup_values jpsv,
777: pa_expenditure_types pet
778: where jpsv.context = jai_constants.setup_expenditure_type and
779: jpsv.attribute1 = pet.expenditure_type_id and
780: pet.expenditure_type =cv_expenditure_type and
781: jpsv.org_id = ln_org_id; /*Bug 8348822 - Tax defaulted based on