APPS.IEU_PVT dependencies on IEU_UWQ_LOGIN_RULES_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;