APPS.JAI_PA_TAX_PKG dependencies on PA_PROJECTS_ALL

Line 361: lv_distribution_rule pa_projects_all.distribution_rule%type ;

357: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
358: ) is
359:
360: ----------------VARIABLE DECLARATIONS---------------------------
361: lv_distribution_rule pa_projects_all.distribution_rule%type ;
362: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
363: ln_process_status varchar2(20) ;
364: -----------------------------------------------------------------
365: ----------------cursor declarations------------------------------

Line 369: from pa_projects_all ppa

365: ----------------cursor declarations------------------------------
366: -- responsible for getting distribution rule of project id
367: cursor cur_distribution_rule is
368: select ppa.distribution_rule
369: from pa_projects_all ppa
370: where ppa.project_id = pn_project_id and
371: distribution_rule is not null ;
372:
373: -- responsible for getting prefernece and context from india localization project setup table

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

370: where ppa.project_id = pn_project_id and
371: distribution_rule is not null ;
372:
373: -- responsible for getting prefernece and context from india localization project setup table
374: cursor cur_context_preference(cv_distribution_rule pa_projects_all.distribution_rule%type ) is
375: select jpsp.distribution_rule , jpsc.context ,jpsp.preference
376: from jai_pa_setup_contexts jpsc , jai_pa_setup_preferences jpsp
377: where jpsc.context_id = jpsp.context_id and
378: jpsp.distribution_rule = cv_distribution_rule

Line 536: from pa_projects_all

532: ln_event_num := pn_event_num ;
533:
534: /*Bug 8348822 - Fetch ORG_ID of the project*/
535: select org_id into ln_org_id
536: from pa_projects_all
537: where project_id = pn_project_id;
538:
539: -- step1
540: -- if event_task_id and ln_evnet_num is found null then returns ........................

Line 623: from pa_projects_all

619: -----------------------------------------------------------------------------
620:
621: /*Bug 8348822 - Fetch ORG_ID of the project*/
622: select org_id into ln_org_id
623: from pa_projects_all
624: where project_id = pn_project_id;
625:
626: open cur_get_project_all ;
627: fetch cur_get_project_all into ln_tax_category_id ;

Line 692: from pa_projects_all

688: -- responsible for getting customer info
689:
690: /*Bug 8348822 - Fetch ORG_ID of the project*/
691: select org_id into ln_org_id
692: from pa_projects_all
693: where project_id = pn_project_id;
694:
695: if pkg_global_type.ln_ship_to_customer_id is null then
696: ln_tax_customer_id := pkg_global_type.ln_bill_to_customer_id ;

Line 794: from pa_projects_all

790: -----------------------------------------------------------------------------
791:
792: /*Bug 8348822 - Fetch ORG_ID of the project*/
793: select org_id into ln_org_id
794: from pa_projects_all
795: where project_id = pn_project_id;
796:
797: open cur_count_expend_type ;
798: fetch cur_count_expend_type into ln_count_expend_type ;