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: BEGIN

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;