DBA Data[Home] [Help]

APPS.GMS_POR_API dependencies on GMS_FP_DISTRIBUTIONS

Line 995: gms_fp_distributions FPD

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
999: and FPH.status = 'A'

Line 1005: gms_fp_distributions gfd,

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
1009: WHERE t.task_id =p_task_id