DBA Data[Home] [Help]

APPS.PA_FORECAST_COST dependencies on PA_PROJECTS_ALL

Line 842: FROM pa_projects_all prj,

838: 'P',get_pa_date(p_item_date,p_exp_org_id))),
839: NVL(tsk.project_rate_type, imp.default_rate_type)
840: INTO l_proj_rate_date,
841: l_proj_rate_type
842: FROM pa_projects_all prj,
843: pa_tasks tsk,
844: pa_implementations_all imp
845: WHERE prj.project_id = p_project_id
846: AND prj.project_id = tsk.project_id

Line 875: FROM pa_projects_all prj,

871: 'P',get_pa_date(p_item_date,p_exp_org_id))),
872: NVL(prj.project_rate_type, imp.default_rate_type)
873: INTO l_proj_rate_date,
874: l_proj_rate_type
875: FROM pa_projects_all prj,
876: pa_implementations_all imp
877: WHERE prj.project_id = p_project_id
878: AND prj.org_id = imp.org_id
879: AND imp.org_id = p_proj_org_id;

Line 1242: pa_projects_all prj

1238: 'INVOICE', prj.inv_ind_sch_fixed_date )
1239: INTO l_burden_sch_id,
1240: l_burden_sch_fixed_date
1241: FROM pa_ind_rate_schedules irs,
1242: pa_projects_all prj
1243: WHERE irs.project_id = prj.project_id
1244: AND irs.project_id = p_project_id
1245: AND irs.task_id is NULL
1246: AND ( (p_schedule_type = 'COST'