APPS.PSP_PSPENORG_XMLP_PKG dependencies on GMS_AWARDS

Line 89: GMS_AWARDS_ALL

85: SELECT
86: AWARD_NUMBER
87: INTO L_AWARD_NUMBER
88: FROM
89: GMS_AWARDS_ALL
90: WHERE AWARD_ID = AWARD_ID1;
91: SELECT
92: NAME
93: INTO L_ORG_NAME

Line 111: GMS_AWARDS GA

107: CURSOR C_AWD_END IS
108: SELECT
109: GA.END_DATE_ACTIVE
110: FROM
111: GMS_AWARDS GA
112: WHERE GA.AWARD_ID = AWARD_ID1;
113: V_AWD_END_DATE DATE;
114: BEGIN
115: IF (AWARD_ID1 IS NOT NULL) THEN