APPS.IBE_WORKFLOW_PVT dependencies on JTF_UM_USERTYPE_REG

Line 365: -- check for user id exists in jtf_um_usertype_reg table

361: l_is_int_primary_user boolean:=false;
362: plsql_block VARCHAR2(500);
363: pv_flag VARCHAR2(1):='N';
364:
365: -- check for user id exists in jtf_um_usertype_reg table
366: -- if not then use the permissions logic to retrieve the user type else return ALL
367: -- The new user type supported out of the box are :
368: -- IBE_INDIVIDUAL, IBE_BUSINESS, IBE_PRIMARY, IBE_PARTNER, IBE_PARTNER_PRIMARY.
369: --

Line 373: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d

369: --
370: -- cursor to retrieve user type from jta tables
371: Cursor c_get_user_type(c_party_id NUMBER) IS
372: select b.usertype_key
373: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d
374: where a.usertype_id=b.usertype_id and c.user_id = a.user_id
375: and d.party_id = c.customer_id and b.application_id=671
376: and d.party_id = c_party_id;
377: