DBA Data[Home] [Help]

APPS.IBE_JTA_INTEGRATION_GRP dependencies on FND_LOOKUP_VALUES

Line 268: from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv

264: l_usertype_key VARCHAR2(240);
265:
266: Cursor C_check_user_type(c_lookup_type VARCHAR2) IS
267: select ut.usertype_key
268: from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv
269: where ut.usertype_id=ureg.usertype_id
270: and ureg.usertype_reg_id=p_user_reg_id
271: and flv.lookup_type=c_lookup_type
272: and ut.usertype_key=flv.lookup_code;

Line 319: from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv

315: l_usertype_key VARCHAR2(240);
316:
317: Cursor C_check_user_type(c_lookup_type VARCHAR2) IS
318: select ut.usertype_key
319: from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv
320: where ut.usertype_id=ureg.usertype_id
321: and ureg.usertype_reg_id=p_user_reg_id
322: and flv.lookup_type=c_lookup_type
323: and ut.usertype_key=flv.lookup_code;