DBA Data[Home] [Help]

APPS.PVX_MISC_PVT dependencies on HZ_ORGANIZATION_PROFILES

Line 1125: FROM hz_relationships HZR, hz_parties PARTNER, hz_organization_profiles HZOP

1121:
1122: -- Cursor : c_party_name
1123: CURSOR c_party_name (cv_partner_id IN NUMBER) IS
1124: SELECT SUBSTRB(PARTNER.party_name,1,44)||'('||PARTNER.party_id||')'
1125: FROM hz_relationships HZR, hz_parties PARTNER, hz_organization_profiles HZOP
1126: WHERE HZR.party_id = cv_partner_id
1127: AND HZR.subject_id = PARTNER.party_id
1128: AND PARTNER.party_id = HZOP.party_id
1129: AND NVL(HZOP.internal_flag,'N') = 'N'