APPS.PV_USER_RESP_PVT dependencies on HZ_RELATIONSHIPS

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 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 5704: FROM hz_relationships hzr,

5700: );
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'