APPS.PV_USER_MGMT_PVT dependencies on FND_USER

Line 907: from fnd_user fndu

903: group by jtfperm.permission_name;
904:
905: cursor get_user_id(l_user_name varchar2) IS
906: Select fndu.user_id
907: from fnd_user fndu
908: where fndu.user_name = l_user_name;
909:
910:
911:

Line 1131: fnd_user fndu, jtf_rs_resource_extns jtfre, (Select column_value from table

1127:
1128: cursor get_users_w_curr_role(cv_role_id JTF_NUMBER_TABLE) IS
1129: select /*+ cardinality( t 10 ) */ jtfp2.principal_name, fndu.user_id
1130: from jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp2,jtf_auth_principals_b jtfp1,
1131: fnd_user fndu, jtf_rs_resource_extns jtfre, (Select column_value from table
1132: (CAST(cv_role_id AS JTF_NUMBER_TABLE))) t
1133: where jtfp1.jtf_auth_principal_id = t.column_value
1134: and jtfp1.is_user_flag = 0
1135: and jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_parent_principal_id

Line 1405: from fnd_user fndu

1401: group by jtfperm.permission_name;
1402:
1403: cursor get_user_id(l_user_name VARCHAR2) IS
1404: select fndu.user_id
1405: from fnd_user fndu
1406: where fndu.user_name = l_user_name;
1407:
1408: cursor get_user_permissions(l_user_name VARCHAR2) IS
1409: select jtfperm.permission_name

Line 1656: fnd_user fndu, jtf_rs_resource_extns jtfre

1652:
1653: cursor get_users_w_curr_role(cv_role_id NUMBER) IS
1654: select jtfp2.principal_name, fndu.user_id
1655: from jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp2,jtf_auth_principals_b jtfp1,
1656: fnd_user fndu, jtf_rs_resource_extns jtfre
1657: where jtfp1.jtf_auth_principal_id = cv_role_id
1658: and jtfp1.is_user_flag = 0
1659: and jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_parent_principal_id
1660: and jtfpm.jtf_auth_principal_id = jtfp2.jtf_auth_principal_id

Line 2066: from fnd_user usr, jtf_um_usertype_reg jureg

2062:
2063: -- get user id, user name, customer id and usertype id
2064: Cursor c_get_user_info(c_reg_id NUMBER, c_user_type VARCHAR2) IS
2065: select usr.user_id, usr.user_name, usr.customer_id, jureg.usertype_id
2066: from fnd_user usr, jtf_um_usertype_reg jureg
2067: where jureg.usertype_reg_id=c_reg_id
2068: and usr.user_id = jureg.user_id;
2069:
2070: -- check if the person is a partner user