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_PRGM_APPROVAL_PVT dependencies on PV_PARTNER_PROFILES

Line 263: FROM pv_partner_profiles glob

259: );
260:
261: CURSOR get_global_csr( sub_ptr_id NUMBER) IS
262: SELECT glob.partner_id
263: FROM pv_partner_profiles glob
264: , hz_relationships rel
265: , pv_partner_profiles sub
266: WHERE glob.partner_party_id= rel.object_id
267: AND rel.subject_id=sub.partner_party_id

Line 265: , pv_partner_profiles sub

261: CURSOR get_global_csr( sub_ptr_id NUMBER) IS
262: SELECT glob.partner_id
263: FROM pv_partner_profiles glob
264: , hz_relationships rel
265: , pv_partner_profiles sub
266: WHERE glob.partner_party_id= rel.object_id
267: AND rel.subject_id=sub.partner_party_id
268: AND sub.partner_id=sub_ptr_id
269: AND relationship_type='PARTNER_HIERARCHY'

Line 2179: ,pv_partner_profiles ppp

2175: ,fl.description enrollment_type
2176: FROM pv_partner_program_vl ppvl
2177: ,fnd_lookups fl
2178: ,pv_pg_enrl_requests pper
2179: ,pv_partner_profiles ppp
2180: ,hz_parties PARTNER
2181: WHERE pper.partner_id = ppp.partner_id
2182: AND ppp.partner_id=PARTNER.party_id
2183: AND fl.lookup_type='PV_ENROLLMENT_REQUEST_TYPE'

Line 2194: ,pv_partner_profiles ppp

2190: ,fl.description enrollment_type
2191: FROM pv_partner_program_vl ppvl
2192: ,fnd_lookups fl
2193: ,pv_pg_enrl_requests pper
2194: ,pv_partner_profiles ppp
2195: ,hz_parties PARTNER
2196:
2197: WHERE pper.partner_id = ppp.partner_id
2198: AND ppp.partner_party_id=PARTNER.party_id

Line 5282: FROM pv_partner_profiles global_prof

5278: AND enty.latest_flag = 'Y';
5279:
5280: CURSOR c_get_global_csr ( p_subs_partner_id IN NUMBER ) IS
5281: SELECT global_prof.partner_id
5282: FROM pv_partner_profiles global_prof
5283: , pv_partner_profiles subs_prof
5284: , hz_relationships rel
5285: WHERE subs_prof.partner_party_id=rel.subject_id
5286: AND rel.relationship_code = 'SUBSIDIARY_OF'

Line 5283: , pv_partner_profiles subs_prof

5279:
5280: CURSOR c_get_global_csr ( p_subs_partner_id IN NUMBER ) IS
5281: SELECT global_prof.partner_id
5282: FROM pv_partner_profiles global_prof
5283: , pv_partner_profiles subs_prof
5284: , hz_relationships rel
5285: WHERE subs_prof.partner_party_id=rel.subject_id
5286: AND rel.relationship_code = 'SUBSIDIARY_OF'
5287: AND rel.relationship_type = 'PARTNER_HIERARCHY'