DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_BUDGET_VERSIONS

Line 100: FROM gms_budget_versions

96: p_Err_Stage OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
97:
98: CURSOR budget_exist IS
99: SELECT 1 --COUNT(*) bug 2355648
100: FROM gms_budget_versions
101: WHERE award_id = p_award_id
102: AND budget_status_code IN ('B','S')
103: AND rownum <=1;
104:

Line 459: FROM gms_budget_versions

455: ) RETURN BOOLEAN IS
456:
457: CURSOR draft_budget_exist IS
458: SELECT 1 --COUNT(*) bug 2355648
459: FROM gms_budget_versions
460: WHERE award_id = p_award_id
461: AND budget_status_code = 'W';
462:
463: l_budget_exist NUMBER :=0;