APPS.PVX_MISC_PVT dependencies on HZ_PARTIES

Line 1116: FROM hz_parties

1112:
1113: -- Cursor : c_party_detail
1114: CURSOR c_party_detail (cv_partner_id IN NUMBER) IS
1115: SELECT SUBSTR(party_name,1,80)
1116: FROM hz_parties
1117: WHERE party_id = cv_partner_id;
1118: -- Cursor related variables
1119: l_group_desc VARCHAR2(240);
1120:

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 1838: FROM hz_parties

1834: AND object_id = p_partner_party_id;
1835:
1836: CURSOR c_party_status (p_party_id IN NUMBER) IS
1837: SELECT NVL(status, 'A') party_status
1838: FROM hz_parties
1839: WHERE party_id = p_party_id;
1840:
1841: CURSOR c_resource_status (p_resource_id IN NUMBER) IS
1842: SELECT start_date_active,

Line 1850: FROM hz_parties

1846:
1847: CURSOR c_party_name (p_party_id IN NUMBER) IS
1848: SELECT SUBSTRB(party_name, 1, 100) partner_name,
1849: party_number partner_number
1850: FROM hz_parties
1851: WHERE party_id = p_party_id;
1852:
1853: l_vendor_party_id NUMBER;
1854: l_start_date DATE;

Line 2109: from pv_partner_profiles pvpp, hz_parties hzp

2105: RETCODE OUT NOCOPY VARCHAR2 ) IS
2106:
2107: CURSOR c_get_partner_wo_accounts IS
2108: select distinct pvpp.partner_party_id, hzp.party_name
2109: from pv_partner_profiles pvpp, hz_parties hzp
2110: where pvpp.status = 'A'
2111: and hzp.party_id = pvpp.partner_party_id
2112: and hzp.status = 'A'
2113: and not exists