APPS.IBE_JTA_INTEGRATION_GRP dependencies on JTF_UM_USERTYPE_REG

Line 50: fnd_user fu, jtf_um_usertype_reg jureg

46:
47: /*
48: Cursor C_get_party_id(c_reg_id NUMBER) IS
49: select fu.customer_id from
50: fnd_user fu, jtf_um_usertype_reg jureg
51: where jureg.usertype_reg_id=c_reg_id
52: and jureg.user_id=fu.user_id;
53: */
54:

Line 57: fnd_user usr, jtf_um_usertype_reg jureg

53: */
54:
55: Cursor C_get_user_id(c_reg_id NUMBER) IS
56: select usr.user_id from
57: fnd_user usr, jtf_um_usertype_reg jureg
58: where jureg.usertype_reg_id=c_reg_id
59: and usr.user_id = jureg.user_id;
60:
61: CURSOR c_lkp(b_usertype_key VARCHAR)

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;