APPS.GMS_POR_API dependencies on GMS_FUNDING_PATTERNS

Line 994: from gms_funding_patterns_all FPH,

990: AND award_distribution_option ='Y';
991:
992: CURSOR check_fund_pattern is
993: SELECT project_id
994: from gms_funding_patterns_all FPH,
995: gms_fp_distributions FPD
996: where FPH.project_id = p_project_id
997: and NVL(FPH.task_id,p_task_id) = p_task_id
998: and FPH.funding_pattern_id= FPD.funding_pattern_id

Line 1004: FROM gms_funding_patterns gfp,

1000: and NVL(FPH.retroactive_flag,'N') = 'N' ;
1001:
1002: CURSOR c_exp_type IS
1003: SELECT gae.expenditure_type
1004: FROM gms_funding_patterns gfp,
1005: gms_fp_distributions gfd,
1006: gms_allowable_expenditures gae,
1007: pa_tasks t,
1008: gms_awards ga