DBA Data[Home] [Help]

APPS.IBE_JTA_INTEGRATION_GRP dependencies on FND_LOOKUP_VALUES

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

275: l_usertype_key VARCHAR2(240);
276:
277: Cursor C_check_user_type(c_lookup_type VARCHAR2) IS
278: select ut.usertype_key
279: from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv
280: where ut.usertype_id=ureg.usertype_id
281: and ureg.usertype_reg_id=p_user_reg_id
282: and flv.lookup_type=c_lookup_type
283: and ut.usertype_key=flv.lookup_code;

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

326: l_usertype_key VARCHAR2(240);
327:
328: Cursor C_check_user_type(c_lookup_type VARCHAR2) IS
329: select ut.usertype_key
330: from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv
331: where ut.usertype_id=ureg.usertype_id
332: and ureg.usertype_reg_id=p_user_reg_id
333: and flv.lookup_type=c_lookup_type
334: and ut.usertype_key=flv.lookup_code;