DBA Data[Home] [Help]

APPS.GMS_POR_API dependencies on GMS_FP_DISTRIBUTIONS

Line 1198: gms_fp_distributions FPD,

1194:
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

Line 1210: gms_fp_distributions gfd,

1206:
1207: CURSOR c_exp_type IS
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