DBA Data[Home] [Help]

APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 140: FROM gms_award_distributions

136: p_Err_Stage OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
137:
138: CURSOR adl_exist IS
139: SELECT 1 --COUNT(*) bug 2355648
140: FROM gms_award_distributions
141: WHERE award_id = p_award_id
142: AND rownum <=1;
143:
144: l_adl_exist NUMBER:=0;