APPS.GMS_POR_API dependencies on GMS_FUNDING_PATTERNS

Line 1197: from gms_funding_patterns_all FPH,

1193: AND award_distribution_option ='Y';
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

Line 1209: FROM gms_funding_patterns gfp,

1205: and NVL(FPH.retroactive_flag,'N') = 'N' ;
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