APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on HZ_LOCATIONS

Line 1045: FROM hz_locations loc,

1041:
1042: CURSOR c_soa_exists(cp_person_id igs_sv_addresses.person_id%TYPE, cp_party_site_id igs_sv_addresses.party_site_id%TYPE)
1043: IS
1044: SELECT 1
1045: FROM hz_locations loc,
1046: hz_party_sites ps,
1047: igs_pe_hz_pty_sites igsps,
1048: hz_party_site_uses usg
1049: WHERE

Line 1060: FROM hz_locations adr,

1056: AND usg.site_use_type = g_site_addr_usage
1057: AND usg.status = 'A'
1058: UNION
1059: SELECT 1
1060: FROM hz_locations adr,
1061: igs_pe_act_site usg
1062: WHERE usg.person_id = cp_person_id
1063: AND SYSDATE BETWEEN nvl(ADDRESS_EFFECTIVE_DATE,sysdate-1) AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE + 1)
1064: AND usg.location_id = adr.location_id

Line 2469: FROM HZ_LOCATIONS loc,

2465: loc.postal_code,
2466: ps.identifying_address_flag primary_site,
2467: to_char(usg.party_site_id) activity_site_cd,
2468: null remarks
2469: FROM HZ_LOCATIONS loc,
2470: HZ_PARTY_SITES ps,
2471: IGS_PE_HZ_PTY_SITES IGSPS,
2472: hz_party_site_uses usg
2473: WHERE

Line 2498: FROM HZ_LOCATIONS adr,

2494: postal_code,
2495: usg.primary_flag primary_site,
2496: usg.activity_site_cd activity_site_cd,
2497: usg.remarks remarks
2498: FROM HZ_LOCATIONS adr,
2499: igs_pe_act_site usg
2500: WHERE usg.person_id = p_person_rec.person_id
2501: AND SYSDATE BETWEEN nvl(ADDRESS_EFFECTIVE_DATE,sysdate-1) AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE + 1)
2502: AND usg.location_id = adr.location_id

Line 2521: from HZ_LOCATIONS loc,

2517: loc.postal_code,
2518: ps.identifying_address_flag primary_site,
2519: to_char(usg.party_site_id) activity_site_cd ,
2520: null remarks
2521: from HZ_LOCATIONS loc,
2522: HZ_PARTY_SITES ps,
2523: IGS_PE_HZ_PTY_SITES IGSPS,
2524: hz_party_site_uses usg
2525: where

Line 2560: from HZ_LOCATIONS loc,

2556: loc.postal_code,
2557: usg.primary_flag primary_site,
2558: usg.activity_site_cd activity_site_cd,
2559: usg.remarks remarks
2560: from HZ_LOCATIONS loc,
2561: igs_pe_act_site usg
2562: where
2563: usg.person_id = p_person_rec.person_id
2564: and (loc.ADDRESS_EXPIRATION_DATE is not null and loc.ADDRESS_EXPIRATION_DATE <= trunc(sysdate) )

Line 2570: HZ_LOCATIONS adr1,

2566: and sysdate between usg.start_date and nvl(usg.end_date,sysdate+1)
2567: and usg.location_id in
2568: ( select adr1.location_id
2569: from igs_sv_addresses ad,
2570: HZ_LOCATIONS adr1,
2571: igs_sv_persons pr
2572: where ad.person_id = pr.person_id
2573: and ad.batch_id = pr.batch_id
2574: and pr.record_status <> 'E'

Line 5552: FROM hz_locations lc, hz_party_sites st

5548: SUBSTR(address1||address2||address3||address4,1,60) addr_line2,
5549: SUBSTR(city,1,60) city ,
5550: SUBSTR(state,1,2) state ,
5551: postal_code
5552: FROM hz_locations lc, hz_party_sites st
5553: WHERE party_id = l_party_id
5554: AND lc.location_id = st.location_id
5555: AND identifying_address_flag ='Y';
5556:

Line 5557: l_postal_code hz_locations.postal_code%TYPE;

5553: WHERE party_id = l_party_id
5554: AND lc.location_id = st.location_id
5555: AND identifying_address_flag ='Y';
5556:
5557: l_postal_code hz_locations.postal_code%TYPE;
5558: l_not_valid BOOLEAN := FALSE;
5559: l_api_name CONSTANT VARCHAR(30) := 'Validate_Empl_Info';
5560: l_counter NUMBER(10):= 0;
5561: