DBA Data[Home] [Help]

APPS.PA_FORECAST_COST dependencies on PA_TASKS

Line 843: pa_tasks tsk,

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
847: AND tsk.task_id = p_task_id

Line 1139: FROM pa_tasks t,

1135: 'REVENUE', t.rev_ind_sch_fixed_date,
1136: 'INVOICE', t.inv_ind_sch_fixed_date)
1137: INTO l_burden_sch_id,
1138: l_burden_sch_fixed_date
1139: FROM pa_tasks t,
1140: pa_ind_rate_schedules irs
1141: WHERE t.task_id = p_task_id
1142: AND t.task_id = irs.task_id
1143: AND ( (p_schedule_type = 'COST'

Line 1315: FROM pa_tasks t

1311: 'REVENUE', t.rev_ind_sch_fixed_date,
1312: 'INVOICE', t.inv_ind_sch_fixed_date)
1313: INTO l_burden_sch_id,
1314: l_burden_sch_fixed_date
1315: FROM pa_tasks t
1316: WHERE t.task_id = p_task_id
1317: AND ( p_schedule_type = 'COST'
1318: OR p_schedule_type = 'REVENUE'
1319: OR p_schedule_type = 'INVOICE'