APPS.IBE_WORKFLOW_PVT dependencies on JTF_UM_USERTYPE_REG

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

371: l_is_int_primary_user boolean:=false;
372: plsql_block VARCHAR2(500);
373: pv_flag VARCHAR2(1):='N';
374:
375: -- check for user id exists in jtf_um_usertype_reg table
376: -- if not then use the permissions logic to retrieve the user type else return ALL
377: -- The new user type supported out of the box are :
378: -- IBE_INDIVIDUAL, IBE_BUSINESS, IBE_PRIMARY, IBE_PARTNER, IBE_PARTNER_PRIMARY.
379: --

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

379: --
380: -- cursor to retrieve user type from jta tables
381: Cursor c_get_user_type(c_party_id NUMBER) IS
382: select b.usertype_key
383: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d
384: where a.usertype_id=b.usertype_id and c.user_id = a.user_id
385: and d.party_id = c.customer_id and b.application_id=671
386: and d.party_id = c_party_id;
387: