APPS.PA_COST dependencies on PA_PROJECTS_ALL

Line 66: l_ot_project_id pa_projects_all.project_id%type;

62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;
67: l_ot_task_id pa_tasks.task_id%type;
68: l_err_code varchar2(200);
69: l_err_stage number;
70: l_return_value varchar2(100);

Line 586: FROM pa_project_types_all typ, pa_projects_all proj

582: -- Get the burden cost flag for the given project type.
583: ------------------------------------------------------
584: SELECT burden_cost_flag
585: INTO l_burden_cost_flag
586: FROM pa_project_types_all typ, pa_projects_all proj
587: WHERE typ.project_type = P_project_type
588: AND proj.project_type = typ.project_type
589: AND proj.project_id = p_project_id
590: AND proj.org_id = typ.org_id; -- bug 5365286

Line 909: l_proj_org_id pa_projects_all.org_id%TYPE;

905: x_msg_data OUT NOCOPY VARCHAR2
906: )
907: IS
908:
909: l_proj_org_id pa_projects_all.org_id%TYPE;
910: l_exp_org_id pa_project_assignments.expenditure_org_id%TYPE; /* Changed for Org Forecasting */
911: l_txn_raw_cost NUMBER; /* Added for Org Forecasting */
912: l_txn_raw_cost_rate NUMBER; /* Added for Org Forecasting */
913: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */

Line 1062: FROM pa_projects_all prj,

1058: 'P',get_pa_date(p_item_date,p_exp_org_id))),
1059: NVL(tsk.project_rate_type, imp.default_rate_type)
1060: INTO l_projfunc_rate_date,
1061: l_projfunc_rate_type
1062: FROM pa_projects_all prj,
1063: pa_tasks tsk,
1064: pa_implementations_all imp
1065: WHERE prj.project_id = p_project_id
1066: AND prj.project_id = tsk.project_id

Line 1087: FROM pa_projects_all prj,

1083: 'P',get_pa_date(p_item_date,p_exp_org_id))),
1084: NVL(prj.projfunc_cost_rate_type, imp.default_rate_type)
1085: INTO l_projfunc_rate_date,
1086: l_projfunc_rate_type
1087: FROM pa_projects_all prj,
1088: pa_implementations_all imp
1089: WHERE prj.project_id = p_project_id
1090: AND nvl(prj.org_id,-99) = nvl(imp.org_id,-99)
1091: AND nvl(imp.org_id,-99) = nvl(p_proj_org_id,-99);

Line 1764: pa_projects_all prj

1760: 'INVOICE', prj.inv_ind_sch_fixed_date )
1761: INTO l_burden_sch_id,
1762: l_burden_sch_fixed_date
1763: FROM pa_ind_rate_schedules irs,
1764: pa_projects_all prj
1765: WHERE irs.project_id = prj.project_id
1766: AND irs.project_id = p_project_id
1767: AND irs.task_id is NULL
1768: AND ( (p_schedule_type = 'COST'

Line 1898: FROM pa_projects_all prj

1894: 'REVENUE', prj.rev_ind_sch_fixed_date,
1895: 'INVOICE', prj.inv_ind_sch_fixed_date)
1896: INTO l_burden_sch_id,
1897: l_burden_sch_fixed_date
1898: FROM pa_projects_all prj
1899: WHERE prj.project_id = p_project_id
1900: AND ( p_schedule_type = 'COST'
1901: OR p_schedule_type = 'REVENUE'
1902: OR p_schedule_type = 'INVOICE'

Line 2051: l_ot_project_id pa_projects_all.project_id%type;

2047: l_override_type pa_compensation_details.override_type%type;
2048: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2049: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2050: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2051: l_ot_project_id pa_projects_all.project_id%type;
2052: l_ot_task_id pa_tasks.task_id%type;
2053: l_err_code varchar2(200);
2054: l_err_stage number;
2055: l_return_value varchar2(100);