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

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

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

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