APPS.GHR_MTI_APP dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 111: FROM GHR_PA_REQUEST_EXTRA_INFO

107:
108: CURSOR PA_REQ_EXT_INFO_CUR (p_pa_request_id number) is
109: SELECT PA_REQUEST_EXTRA_INFO_ID,
110: OBJECT_VERSION_NUMBER
111: FROM GHR_PA_REQUEST_EXTRA_INFO
112: WHERE INFORMATION_TYPE = 'GHR_US_PAR_APPT_TRANSFER'
113: and pa_request_id = p_pa_request_id;
114:
115: --Begin Bug# 8724192

Line 119: FROM GHR_PA_REQUEST_EXTRA_INFO

115: --Begin Bug# 8724192
116: CURSOR PA_REQ_NTE_EI_CUR (p_pa_request_id number) is
117: SELECT PA_REQUEST_EXTRA_INFO_ID,
118: OBJECT_VERSION_NUMBER
119: FROM GHR_PA_REQUEST_EXTRA_INFO
120: WHERE INFORMATION_TYPE = 'GHR_US_MASS_TRNSFR_NTE_DATES'
121: and pa_request_id = p_pa_request_id;
122:
123: CURSOR PA_REQ_APP_AUTH_EI_CUR (p_pa_request_id number) is

Line 126: FROM GHR_PA_REQUEST_EXTRA_INFO

122:
123: CURSOR PA_REQ_APP_AUTH_EI_CUR (p_pa_request_id number) is
124: SELECT PA_REQUEST_EXTRA_INFO_ID,
125: OBJECT_VERSION_NUMBER
126: FROM GHR_PA_REQUEST_EXTRA_INFO
127: WHERE INFORMATION_TYPE = 'GHR_US_TRANS_CURN_APP_AUTH'
128: and pa_request_id = p_pa_request_id;
129:
130: --End Bug# 8724192