DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PUB dependencies on HZ_ORGANIZATION_PROFILES

Line 118: hz_organization_profiles op,

114:
115: cursor lc_get_pt_org_name (pc_partner_id number) is
116: select pt.party_name
117: from hz_relationships pr,
118: hz_organization_profiles op,
119: hz_parties pt
120: where pr.party_id = pc_partner_id
121: and pr.subject_table_name = 'HZ_PARTIES'
122: and pr.object_table_name = 'HZ_PARTIES'

Line 1920: hz_organization_profiles op,

1916:
1917: cursor lc_get_pt_org_name (pc_partner_id number) is
1918: select pt.party_name
1919: from hz_relationships pr,
1920: hz_organization_profiles op,
1921: hz_parties pt
1922: where pr.party_id = pc_partner_id
1923: and pr.subject_table_name = 'HZ_PARTIES'
1924: and pr.object_table_name = 'HZ_PARTIES'

Line 3472: hz_organization_profiles op,

3468:
3469: cursor lc_get_pt_org_name (pc_partner_id number) is
3470: select pt.party_name
3471: from hz_relationships pr,
3472: hz_organization_profiles op,
3473: hz_parties pt
3474: where pr.party_id = pc_partner_id
3475: and pr.subject_table_name = 'HZ_PARTIES'
3476: and pr.object_table_name = 'HZ_PARTIES'