APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_ADDR_V

Line 1021: FROM igs_pe_addr_v adr,

1017:
1018: CURSOR c_f_addr_exists(cp_person_id igs_sv_addresses.person_id%TYPE, cp_party_site_id igs_sv_addresses.party_site_id%TYPE)
1019: IS
1020: SELECT 1
1021: FROM igs_pe_addr_v adr,
1022: igs_pe_partysiteuse_v usg
1023: WHERE person_id = cp_person_id
1024: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
1025: AND usg.party_site_id = adr.party_site_id

Line 1033: FROM igs_pe_addr_v adr,

1029:
1030: CURSOR c_us_addr_exists(cp_person_id igs_sv_addresses.person_id%TYPE, cp_party_site_id igs_sv_addresses.party_site_id%TYPE)
1031: IS
1032: SELECT 1
1033: FROM igs_pe_addr_v adr,
1034: igs_pe_partysiteuse_v usg
1035: WHERE person_id = cp_person_id
1036: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
1037: AND usg.party_site_id = adr.party_site_id

Line 2095: FROM igs_pe_addr_v adr,

2091: province,
2092: country_cd,
2093: postal_code,
2094: identifying_address_flag
2095: FROM igs_pe_addr_v adr,
2096: igs_pe_partysiteuse_v usg
2097: WHERE person_id = p_person_rec.person_id
2098: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
2099: AND usg.party_site_id = adr.party_site_id

Line 2279: FROM igs_pe_addr_v adr,

2275: province,
2276: country_cd,
2277: postal_code,
2278: adr.identifying_address_flag
2279: FROM igs_pe_addr_v adr,
2280: igs_pe_partysiteuse_v usg
2281: WHERE person_id = p_person_rec.person_id
2282: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
2283: AND usg.party_site_id = adr.party_site_id

Line 2434: Replaced IGS_PE_ADDR_V with IGS_AD_LOCVENUE_ADDR_V while joining with IGS_PE_ACT_SITE

2430:
2431: Change History
2432: Who When What
2433: pkpatel 23-APR-2003 Bug No 2908378
2434: Replaced IGS_PE_ADDR_V with IGS_AD_LOCVENUE_ADDR_V while joining with IGS_PE_ACT_SITE
2435: Selected LOCATION_ID instead of PARTY_SITE_ID for these cases.
2436: Added p_data_rec(l_counter).party_site_id := c_addr_rec.party_site_id
2437: gmaheswa 12-Nov-2003 Modified c_addr cursor to select active address records,
2438: as part of address related changes .

Line 2590: FROM igs_pe_addr_v adr,

2586: a.primary_flag = 'Y' /*AND
2587: (a.end_date IS NULL OR sysdate between a.start_date and a.end_date)*/
2588: UNION
2589: SELECT adr.party_site_id
2590: FROM igs_pe_addr_v adr,
2591: hz_party_site_uses usg
2592: WHERE person_id = p_person_rec.person_id
2593: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(adr.start_dt,SYSDATE) AND NVL(adr.end_dt, SYSDATE + 1))
2594: AND usg.party_site_id = adr.party_site_id