[Home] [Help]
129: SELECT
130: DEFAULT_DIST_AWARD_NUMBER
131: INTO L_AWARD_NUMBER
132: FROM
133: GMS_IMPLEMENTATIONS
134: WHERE DEFAULT_DIST_AWARD_ID = AWARD_ID_V
135: AND AWARD_DISTRIBUTION_OPTION = 'Y';
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN