APPS.PV_ASSIGNMENT_PUB dependencies on PV_PARTNER_PROFILES

Line 170: pv_partner_profiles prof,

166: select emp.object_id pt_org_id,
167: hp.party_name,
168: prof.partner_id
169: from hz_relationships emp,
170: pv_partner_profiles prof,
171: hz_parties hp
172: where emp.party_id = pc_user_source_id
173: and emp.subject_table_name = 'HZ_PARTIES'
174: and emp.object_table_name = 'HZ_PARTIES'

Line 205: from pv_partner_profiles pvpp

201: -- for bug# 4325252
202:
203: cursor lc_chk_pt_status (pc_partner_id number) is
204: select 1 num
205: from pv_partner_profiles pvpp
206: where pvpp.partner_id = pc_partner_id
207: and nvl(pvpp.status,'I') <> 'A';
208:
209: cursor lc_validate_vad_pt (pc_partner_id number, pc_vad_id number) is

Line 213: pv_partner_profiles PT_PROF,

209: cursor lc_validate_vad_pt (pc_partner_id number, pc_vad_id number) is
210: select PT_ORG.party_name
211: from
212: pv_partner_accesses PT_ACCESS,
213: pv_partner_profiles PT_PROF,
214: hz_parties PT_ORG
215: where
216: PT_ACCESS.partner_id = pc_partner_id
217: and PT_ACCESS.partner_id = PT_PROF.partner_id

Line 3451: pv_partner_profiles pt,

3447: re.resource_id
3448: from fnd_user fu,
3449: jtf_rs_resource_extns re,
3450: hz_relationships emp,
3451: pv_partner_profiles pt,
3452: pv_lead_assignments la
3453: where fu.user_name = pc_user_name
3454: and fu.user_id = re.user_id
3455: and re.category = 'PARTY'