eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_USER_RESP_PVT dependencies on PV_PARTNER_PROFILES

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 2930: FROM pv_partner_profiles

2926: SELECT responsibility_id
2927: FROM pv_ge_ptnr_resps
2928: WHERE partner_id in (
2929: SELECT partner_id
2930: FROM pv_partner_profiles
2931: WHERE partner_party_id in (
2932: SELECT partner_party_id
2933: FROM pv_partner_profiles
2934: WHERE partner_id = p_partner_id

Line 2933: FROM pv_partner_profiles

2929: SELECT partner_id
2930: FROM pv_partner_profiles
2931: WHERE partner_party_id in (
2932: SELECT partner_party_id
2933: FROM pv_partner_profiles
2934: WHERE partner_id = p_partner_id
2935: )
2936: AND partner_id <> p_partner_id
2937: )

Line 5462: FROM pv_partner_profiles

5458: SELECT responsibility_id
5459: FROM pv_ge_ptnr_resps
5460: WHERE partner_id in (
5461: SELECT partner_id
5462: FROM pv_partner_profiles
5463: WHERE partner_party_id in (
5464: SELECT partner_party_id
5465: FROM pv_partner_profiles
5466: WHERE partner_id = cv_partner_id

Line 5465: FROM pv_partner_profiles

5461: SELECT partner_id
5462: FROM pv_partner_profiles
5463: WHERE partner_party_id in (
5464: SELECT partner_party_id
5465: FROM pv_partner_profiles
5466: WHERE partner_id = cv_partner_id
5467: )
5468: AND partner_id <> cv_partner_id
5469: )

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 5706: pv_partner_profiles pvpp, fnd_user fndu

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
5710: AND hzr.directional_flag = 'F'

Line 5993: FROM pv_partner_profiles

5989: )
5990: IS
5991: CURSOR c_get_partner_id IS
5992: SELECT partner_id
5993: FROM pv_partner_profiles
5994: WHERE partner_party_id = p_org_party_id;
5995:
5996: CURSOR c_get_resp_info (cv_partner_id NUMBER) IS
5997: SELECT ptnr_resp_id, responsibility_id, partner_id, program_id,

Line 6950: FROM pv_partner_profiles prof

6946: x_msg_data VARCHAR2(2000);
6947: l_key VARCHAR2(240) := p_event.GetEventKey();
6948: CURSOR get_party_id_csr ( p_location_id IN NUMBER ) IS
6949: SELECT partner_party_id
6950: FROM pv_partner_profiles prof
6951: , hz_party_sites st
6952: , hz_locations loc
6953: WHERE prof.partner_party_id = st.party_id
6954: AND prof.status = 'A'

Line 6963: pv_partner_profiles ppp

6959:
6960: CURSOR is_partner_csr (cv_party_site_id NUMBER) IS
6961: SELECT partner_id
6962: FROM hz_party_sites hzps,
6963: pv_partner_profiles ppp
6964: WHERE hzps.party_site_id = cv_party_site_id
6965: AND hzps.status = 'A'
6966: AND hzps.identifying_address_flag = 'Y'
6967: AND ppp.partner_party_id = hzps.party_id

Line 7018: /* check if the party_id exists in pv_partner_profiles table and

7014: IF (PV_DEBUG_HIGH_ON) THEN
7015: WRITE_LOG(l_api_name, 'oracle.apps.ar.hz.PartySite.update event fired');
7016: END IF;
7017:
7018: /* check if the party_id exists in pv_partner_profiles table and
7019: also make sure that the address change is for the location of primary address..
7020: if yes..call resp mapping api
7021: */
7022: OPEN is_partner_csr( l_party_site_id );