APPS.PV_USER_MGMT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 73: from jtf_rs_resource_extns

69:
70:
71: cursor c_get_resource_id (cv_person_rel_party_id NUMBER)is
72: select resource_id, resource_number, user_id, object_version_number
73: from jtf_rs_resource_extns
74: where source_id = cv_person_rel_party_id
75: and category='PARTY'
76: and start_date_active <= sysdate
77: and (end_date_active is null or end_date_active >= sysdate);

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 1423: (select 'X' from jtf_rs_resource_extns

1419:
1420: cursor validate_partner_user(l_user_id NUMBER) IS
1421: select 'X' from dual
1422: where exists
1423: (select 'X' from jtf_rs_resource_extns
1424: where user_id = l_user_id and category='PARTY');
1425:
1426: is_prtnr_perm_assigned boolean := false;
1427: is_primary_perm_assigned boolean := false;

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 1983: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp

1979: cursor cv_is_partner_user(l_rel_party_id NUMBER) IS
1980: select 1 from dual where exists
1981: (
1982: select /*+ use_nl (hzr res) */ pvpp.partner_id, hzr.party_id, hzr.subject_id ,pvpp.partner_party_id
1983: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp
1984: where RES.category = 'PARTY' and RES.source_id = 6310
1985: and RES.start_date_active <= SYSDATE
1986: and (RES.end_date_active is null or RES.end_date_active > SYSDATE)
1987: and RES.source_id = hzr.party_id and hzr.directional_flag = 'F'