APPS.PSP_PSPENAWD_XMLP_PKG dependencies on GMS_AWARDS
Line 76: GMS_AWARDS_ALL
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
Line 97: GMS_AWARDS GA
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