APPS.IBE_ADDRESS_V2PVT dependencies on HZ_PARTY_SITES

Line 1280: FROM hz_party_sites ps, hz_party_site_uses psu, hz_locations loc, hr_organization_information hr

1276: l_contact_org_id NUMBER;
1277:
1278: cursor c_getPrimAddrId_2(l_party_id NUMBER,l_org_id NUMBER,hr_type VARCHAR2,site_type VARCHAR2) IS
1279: SELECT ps.party_site_id
1280: FROM hz_party_sites ps, hz_party_site_uses psu, hz_locations loc, hr_organization_information hr
1281: WHERE
1282: ps.party_id = l_party_id AND
1283: ps.status = 'A' AND
1284: ps.location_id = loc.location_id AND

Line 1322: FROM hz_party_sites ps, hz_party_site_uses psu

1318: );
1319:
1320: cursor c_getPrimAddrId_1(l_party_id NUMBER,l_org_id NUMBER,hr_type VARCHAR2,site_type VARCHAR2) IS
1321: SELECT ps.party_site_id
1322: FROM hz_party_sites ps, hz_party_site_uses psu
1323: WHERE
1324: ps.party_id = l_party_id AND
1325: ps.status = 'A' AND
1326: ps.party_site_id = psu.party_site_id AND

Line 1553: hz_party_sites_v

1549: party_site_id, location_id
1550: INTO
1551: x_party_site_id, x_location_id
1552: FROM
1553: hz_party_sites_v
1554: WHERE
1555: party_id = p_party_id AND
1556: site_use_type = p_site_use_type AND
1557: status = 'A' AND

Line 1737: FROM hz_party_sites_v

1733: INTO l_party_site_number
1734: FROM dual;
1735:
1736: SELECT COUNT(*) INTO l_count
1737: FROM hz_party_sites_v
1738: WHERE party_site_number = l_party_site_number;
1739:
1740: END LOOP;
1741:

Line 2196: FROM hz_party_sites

2192: END IF;
2193:
2194: BEGIN
2195: SELECT party_site_id INTO l_dummy
2196: FROM hz_party_sites
2197: WHERE party_site_id = p_party_site.party_site_id
2198: AND nvl(party_site_name,l_gmiss)=nvl(p_party_site.party_site_name,l_gmiss)
2199: AND nvl(addressee,l_gmiss)= nvl(p_party_site.addressee,l_gmiss)
2200: AND (identifying_address_flag = 'Y' or p_party_site.identifying_address_flag='N');

Line 2309: (SELECT location_id FROM hz_party_sites

2305:
2306: CURSOR c1(l_c_party_site_id IN NUMBER)
2307: IS SELECT country FROM hz_locations
2308: WHERE location_id IN
2309: (SELECT location_id FROM hz_party_sites
2310: WHERE party_site_id = l_c_party_site_id);
2311:
2312: CURSOR c2(l_c_operating_unit_id IN NUMBER, l_c_usage_code IN VARCHAR2)
2313: IS SELECT org_information1 FROM hr_organization_information