APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_PARTYSITEUSE_V

Line 1022: igs_pe_partysiteuse_v usg

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
1026: AND adr.party_site_id = cp_party_site_id

Line 1034: igs_pe_partysiteuse_v usg

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
1038: AND adr.party_site_id = cp_party_site_id

Line 2096: igs_pe_partysiteuse_v usg

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
2100: AND usg.site_use_type = g_f_addr_usage

Line 2280: igs_pe_partysiteuse_v usg

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
2284: AND usg.site_use_type = g_us_addr_usage