APPS.PV_WORKFLOW_PUB dependencies on HZ_PARTIES

Line 3043: hz_parties e,

3039: from
3040: PV_LEAD_ASSIGNMENTS C,
3041: pv_oppty_routing_logs a,
3042: pv_partner_profiles d,
3043: hz_parties e,
3044: HR_ALL_ORGANIZATION_UNITS_TL h
3045: where
3046: c.wf_item_type = 'PVASGNMT'
3047: and c.wf_item_key = (select substr(context,10,LENGTH(CONTEXT)-10)

Line 3081: from hz_relationships hzr, hz_parties hzp

3077: select
3078: case
3079: when a.vendor_user_id is null then
3080: (select hzp.party_name
3081: from hz_relationships hzr, hz_parties hzp
3082: where hzr.party_id=g.source_id and hzr.subject_type='PERSON' and
3083: hzr.subject_id=hzp.party_id and hzr.object_type= 'ORGANIZATION' )
3084: else (g.source_first_name || ' ' || g.source_last_name)
3085: end person_name