APPS.AHL_FMP_MR_RELATION_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 140: FROM AHL_MR_HEADERS_APP_V A

136: as
137: CURSOR title_to_relmr_header_id(C_TITLE IN VARCHAR2,C_TYPE_CODE VARCHAR2)
138: IS
139: SELECT MR_HEADER_ID
140: FROM AHL_MR_HEADERS_APP_V A
141: WHERE UPPER(TITLE)=(C_TITLE)
142: AND MR_STATUS_CODE<>'TERMINATED'
143: AND trunc(NVL(EFFECTIVE_TO,SYSDATE+1))>SYSDATE
144: AND NVL(TYPE_CODE,'X')=DECODE(C_TYPE_CODE,'ACTIVITY','PROGRAM', 'PROGRAM','ACTIVITY','X');

Line 149: FROM AHL_MR_HEADERS_APP_V

145:
146: CURSOR c_mr_header_id_to_relmr_title(C_MR_HEADER_ID IN NUMBER,C_TYPE_CODE VARCHAR2)
147: IS
148: SELECT TITLE
149: FROM AHL_MR_HEADERS_APP_V
150: WHERE MR_HEADER_ID=C_MR_HEADER_ID
151: AND MR_STATUS_CODE<>'TERMINATED'
152: AND trunc(NVL(EFFECTIVE_TO,SYSDATE+1))>SYSDATE
153: AND NVL(TYPE_CODE,'X')=DECODE(NVL(C_TYPE_CODE,'X'),'ACTIVITY','PROGRAM','PROGRAM','ACTIVITY','X');