APPS.PV_USER_RESP_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 233: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu

229: CURSOR c_primary_user_ids IS
230: SELECT user_id
231: FROM (
232: SELECT jtfre.user_id user_id, pvpp.partner_id partner_id
233: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu
234: WHERE pvpp.partner_party_id = hzr.object_id
235: AND hzr.relationship_code = 'EMPLOYEE_OF'
236: AND HZR.subject_table_name ='HZ_PARTIES'
237: AND HZR.object_table_name ='HZ_PARTIES'

Line 272: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu

268: CURSOR c_business_user_ids IS
269: SELECT user_id
270: FROM (
271: SELECT jtfre.user_id user_id, pvpp.partner_id partner_id
272: FROM pv_partner_profiles pvpp, hz_relationships hzr, jtf_rs_resource_extns jtfre, fnd_user fndu
273: WHERE pvpp.partner_party_id = hzr.object_id
274: AND hzr.relationship_code = 'EMPLOYEE_OF'
275: AND HZR.subject_table_name ='HZ_PARTIES'
276: AND HZR.object_table_name ='HZ_PARTIES'

Line 387: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp

383: l_index NUMBER := 1;
384:
385: CURSOR c_get_partner_id IS
386: select pvpp.partner_id partner_id
387: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp
388: where RES.user_id = p_user_id
389: and RES.category = 'PARTY'
390: and RES.start_date_active <= SYSDATE and nvl(RES.end_date_active , sysdate) >= SYSDATE
391: and RES.source_id = hzr.party_id and hzr.directional_flag = 'F'

Line 2373: from jtf_rs_resource_extns extn, fnd_user usr

2369: )
2370: IS
2371: CURSOR c_get_user_id IS
2372: select usr.user_id
2373: from jtf_rs_resource_extns extn, fnd_user usr
2374: where extn.user_id = usr.user_id
2375: and usr.user_name = p_user_name;
2376:
2377: l_api_name CONSTANT VARCHAR2(30) := 'assign_user_resps';

Line 5113: from jtf_rs_resource_extns extn, fnd_user usr

5109: IS
5110:
5111: CURSOR c_get_user_id IS
5112: select usr.user_id
5113: from jtf_rs_resource_extns extn, fnd_user usr
5114: where extn.user_id = usr.user_id
5115: and usr.user_name = p_user_name;
5116:
5117: l_api_name CONSTANT VARCHAR2(30) := 'revoke_user_resps';

Line 5662: FROM hz_relationships hzr, jtf_rs_resource_extns jtfre, pv_partner_profiles pvpp, fnd_user fndu

5658: )
5659: IS
5660: CURSOR c_get_primary_users IS
5661: SELECT jtfre.user_id user_id
5662: FROM hz_relationships hzr, jtf_rs_resource_extns jtfre, pv_partner_profiles pvpp, fnd_user fndu
5663: WHERE pvpp.partner_id = p_partner_id
5664: AND pvpp.status = 'A'
5665: AND pvpp.partner_party_id = hzr.object_id
5666: AND hzr.directional_flag = 'F'

Line 5705: jtf_rs_resource_extns jtfre,

5701:
5702: CURSOR c_get_business_users IS
5703: SELECT jtfre.user_id user_id
5704: FROM hz_relationships hzr,
5705: jtf_rs_resource_extns jtfre,
5706: pv_partner_profiles pvpp, fnd_user fndu
5707: WHERE pvpp.partner_id = p_partner_id
5708: AND pvpp.status = 'A'
5709: AND pvpp.partner_party_id = hzr.object_id