APPS.PV_USER_MGMT_PVT dependencies on FND_USER

Line 905: from fnd_user fndu

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

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

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

Line 1403: from fnd_user fndu

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

Line 1654: fnd_user fndu, jtf_rs_resource_extns jtfre

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

Line 2064: from fnd_user usr, jtf_um_usertype_reg jureg

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