APPS.IBE_WORKFLOW_PVT dependencies on JTF_UM_USERTYPES_B

Line 358: l_UserType jtf_um_usertypes_b.usertype_key%type :='ALL';

354: pUserType OUT NOCOPY Varchar2) IS
355:
356: l_api_name CONSTANT VARCHAR2(30) :='getUserType';
357: l_PartyType HZ_PARTIES.PARTY_TYPE%type :='';
358: l_UserType jtf_um_usertypes_b.usertype_key%type :='ALL';
359: l_user_name FND_USER.USER_NAME%type;
360: l_is_pv_partner boolean :=false;
361: l_is_int_primary_user boolean:=false;
362: plsql_block VARCHAR2(500);

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:

Line 1351: select approval_id from jtf_um_usertypes_b

1347: Where USR.EMPLOYEE_ID is null
1348: and user_name = c_login_name;
1349: -- ab
1350: Cursor C_get_approval_id(c_usertype VARCHAR2) IS
1351: select approval_id from jtf_um_usertypes_b
1352: where usertype_key=c_usertype and (effective_end_date > sysdate or effective_end_date is null)
1353: and rownum= 1 and application_id=671;
1354:
1355: Cursor C_get_org_num(c_party_id NUMBER) IS