[Home] [Help]
72: SELECT
73: AWARD_NUMBER
74: INTO L_AWARD_NUMBER
75: FROM
76: GMS_AWARDS_ALL
77: WHERE AWARD_ID = CF_CHARGING_INSTFORMULA.AWARD_ID;
78: SELECT
79: NAME
80: INTO L_ORG_NAME
93: CURSOR C_AWD_END IS
94: SELECT
95: GA.END_DATE_ACTIVE
96: FROM
97: GMS_AWARDS GA
98: WHERE GA.AWARD_ID = CF_AWD_END_DTFORMULA.AWARD_ID;
99: V_AWD_END_DATE DATE;
100: BEGIN
101: IF (AWARD_ID IS NOT NULL) THEN