APPS.OKC_QCL_PVT dependencies on FND_APPLICATION

Line 182: from fnd_application

178: x_return_status OUT NOCOPY VARCHAR2,
179: p_qclv_rec IN qclv_rec_type) IS
180: Cursor application_id_cur(p_application_id IN NUMBER) IS
181: select '1'
182: from fnd_application
183: where application_id = p_application_id;
184: l_app_id VARCHAR2(1) := '?';
185: BEGIN
186: -- initialize return status

Line 190: --Check whether application id exists in the fnd_application or not

186: -- initialize return status
187: x_return_status := OKC_API.G_RET_STS_SUCCESS;
188:
189: IF ((p_qclv_rec.application_id IS NOT NULL) AND (p_qclv_rec.application_id <> OKC_API.G_MISS_NUM)) THEN
190: --Check whether application id exists in the fnd_application or not
191: OPEN application_id_cur(p_qclv_rec.application_id);
192: FETCH application_id_cur INTO l_app_id;
193: CLOSE application_id_cur ;
194: IF l_app_id = '?' THEN

Line 863: FROM fnd_application_vl

859: AND id <> p_qclv_rec.id;
860:
861: CURSOR cur_app_name is
862: SELECT application_name
863: FROM fnd_application_vl
864: WHERE application_id = p_qclv_rec.application_id;
865:
866: l_row_found BOOLEAN := FALSE;
867: l_default VARCHAR2(1);