APPS.IBE_ADDRESS_V2PVT dependencies on HR_ORGANIZATION_INFORMATION

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 1333: FROM hr_organization_information hr

1329: psu.status = 'A' AND
1330: NVL(psu.end_date,sysdate+1) > sysdate AND
1331: NOT EXISTS (
1332: SELECT 1
1333: FROM hr_organization_information hr
1334: WHERE
1335: hr.organization_id = l_org_id AND
1336: hr.org_information_context = hr_type AND
1337: rownum = 1) AND

Line 2313: IS SELECT org_information1 FROM hr_organization_information

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
2314: WHERE organization_id = l_c_operating_unit_id
2315: AND org_information_context = l_c_usage_code;
2316:
2317: BEGIN