APPS.IEU_PVT dependencies on IEU_UWQ_MEDIA_TYPES_B

Line 286: from ieu_uwq_media_types_b a, ieu_uwq_login_rules_b b

282: begin
283: select a.tel_reqd_flag, decode(b.login_rule_type, 'FUNC', b.login_rule, null),
284: decode(b.login_rule_type, 'MUUID', b.login_rule, null)
285: into l_tel_reqd_flag, l_svr_connect_rule, l_tel_media_type
286: from ieu_uwq_media_types_b a, ieu_uwq_login_rules_b b
287: where a.media_type_uuid = l_media_type_uuid
288: and a.svr_login_rule_id = b.svr_login_rule_id(+);
289: exception
290: when no_data_found then null;

Line 336: from ieu_uwq_media_types_b a, ieu_uwq_login_rules_b b

332:
333: select a.media_type_id, a.media_type_uuid, a.tel_reqd_flag, decode(b.login_rule_type, 'FUNC', b.login_rule, null),
334: decode(b.login_rule_type, 'MUUID', b.login_rule, null)
335: into l_media_type_id_1, l_media_type_uuid_1, l_tel_reqd_flag, l_svr_connect_rule, l_tel_media_type
336: from ieu_uwq_media_types_b a, ieu_uwq_login_rules_b b
337: where a.media_type_uuid = l_media_type_uuid_1
338: and a.svr_login_rule_id = b.svr_login_rule_id(+);
339:
340: X_ALL_MEDIA_LIST(l_ctr).MEDIA_TYPE_ID := l_media_type_id_1;

Line 396: IEU_UWQ_MEDIA_TYPES_B mttab

392: /* JTF_RS_RESOURCE_EXTNS restab,
393: IEO_SVR_SERVERS svrtab,
394: IEO_SVR_SERVERS svrtab2,
395: IEU_UWQ_SVR_MPS_MMAPS mmptab,
396: IEU_UWQ_MEDIA_TYPES_B mttab
397: WHERE
398: (restab.RESOURCE_ID = p_resource_id) AND
399: (restab.SERVER_GROUP_ID IS NOT NULL) AND
400: ( (svrtab.MEMBER_SVR_GROUP_ID IS NOT NULL) AND

Line 414: IEU_UWQ_MEDIA_TYPES_B mttab

410: ) AND
411: (svrtab.TYPE_ID = mmptab.SVR_TYPE_ID) AND
412: (mmptab.MEDIA_TYPE_ID = mttab.MEDIA_TYPE_ID);
413: */
414: IEU_UWQ_MEDIA_TYPES_B mttab
415: WHERE
416: mttab.MEDIA_TYPE_ID in
417: (SELECT MEDIA_TYPE_ID
418: FROM IEU_UWQ_SVR_MPS_MMAPS