APPS.PVX_MISC_PVT dependencies on HZ_RELATIONSHIPS

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'

Line 1832: FROM hz_relationships

1828: SELECT subject_id vendor_party_id,
1829: start_date,
1830: end_date,
1831: status
1832: FROM hz_relationships
1833: WHERE party_id = p_party_id
1834: AND object_id = p_partner_party_id;
1835:
1836: CURSOR c_party_status (p_party_id IN NUMBER) IS

Line 2121: from jtf_rs_resource_extns jtfre, hz_relationships hzr, hz_cust_accounts hzca

2117: and hzca.party_id = pvpp.partner_party_id);
2118:
2119: CURSOR c_get_prtnrcntct_wo_role IS
2120: select hzr.party_id, max(hzca.cust_account_id) cust_account_id
2121: from jtf_rs_resource_extns jtfre, hz_relationships hzr, hz_cust_accounts hzca
2122: where jtfre.category= 'PARTY'
2123: and jtfre.user_id is not null
2124: and jtfre.source_id = hzr.party_id
2125: and hzr.object_id in (select pvpp.partner_party_id