APPS.JAI_PA_TAX_PKG dependencies on PA_PROJECTS_ALL

Line 350: lv_distribution_rule pa_projects_all.distribution_rule%type ;

346: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
347: ) is
348:
349: ----------------VARIABLE DECLARATIONS---------------------------
350: lv_distribution_rule pa_projects_all.distribution_rule%type ;
351: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
352: ln_process_status varchar2(20) ;
353: -----------------------------------------------------------------
354: ----------------cursor declarations------------------------------

Line 358: from pa_projects_all ppa

354: ----------------cursor declarations------------------------------
355: -- responsible for getting distribution rule of project id
356: cursor cur_distribution_rule is
357: select ppa.distribution_rule
358: from pa_projects_all ppa
359: where ppa.project_id = pn_project_id and
360: distribution_rule is not null ;
361:
362: -- responsible for getting prefernece and context from india localization project setup table

Line 363: cursor cur_context_preference(cv_distribution_rule pa_projects_all.distribution_rule%type ) is

359: where ppa.project_id = pn_project_id and
360: distribution_rule is not null ;
361:
362: -- responsible for getting prefernece and context from india localization project setup table
363: cursor cur_context_preference(cv_distribution_rule pa_projects_all.distribution_rule%type ) is
364: select jpsp.distribution_rule , jpsc.context ,jpsp.preference
365: from jai_pa_setup_contexts jpsc , jai_pa_setup_preferences jpsp
366: where jpsc.context_id = jpsp.context_id and
367: jpsp.distribution_rule = cv_distribution_rule