DBA Data[Home] [Help]

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