DBA Data[Home] [Help]

APPS.GMS_POR_API dependencies on PA_TASKS

Line 1199: pa_tasks t -- bug 9883567 Added

1195: CURSOR check_fund_pattern is
1196: SELECT fph.project_id
1197: from gms_funding_patterns_all FPH,
1198: gms_fp_distributions FPD,
1199: pa_tasks t -- bug 9883567 Added
1200: where FPH.project_id = p_project_id
1201: and t.task_id = p_task_id
1202: and NVL(FPH.task_id,t.top_task_id) = t.top_task_id
1203: and FPH.funding_pattern_id= FPD.funding_pattern_id

Line 1212: pa_tasks t,

1208: SELECT gae.expenditure_type
1209: FROM gms_funding_patterns gfp,
1210: gms_fp_distributions gfd,
1211: gms_allowable_expenditures gae,
1212: pa_tasks t,
1213: gms_awards ga
1214: WHERE t.task_id =p_task_id
1215: AND t.project_id =p_project_id
1216: AND gfp.project_id =p_project_id