APPS.IGS_AD_IMP_008 dependencies on IGS_PE_ADDR_V

Line 727: FROM IGS_PE_ADDR_V

723: p_state igs_ad_reladdr_int.state%TYPE,
724: p_party_id NUMBER
725: ) IS
726: SELECT *
727: FROM IGS_PE_ADDR_V
728: WHERE UPPER(addr_line_1) = UPPER(p_addr_line_1)
729: AND UPPER(nvl(addr_line_2,'NulL')) = UPPER(nvl(p_addr_line_2,'NulL'))
730: AND UPPER(nvl(addr_line_3,'NulL')) = UPPER(nvl(p_addr_line_3,'NulL'))
731: AND UPPER(nvl(addr_line_4,'NulL')) = UPPER(nvl(p_addr_line_4,'NulL'))

Line 743: CURSOR site_c (p_party_site_id igs_pe_addr_v.party_site_id%TYPE,

739: addr_rec addr_c%ROWTYPE;
740:
741:
742: --Check to see if for this address these two site usages exist.
743: CURSOR site_c (p_party_site_id igs_pe_addr_v.party_site_id%TYPE,
744: p_site_use_code igs_ad_reladdr_int.site_use_code_1%TYPE ) IS
745: SELECT site_use_type,party_site_use_id,last_update_date
746: FROM HZ_PARTY_SITE_USES
747: WHERE PARTY_SITE_ID = p_party_site_id

Line 778: CURSOR site_c (p_party_site_id igs_pe_addr_v.party_site_id%TYPE,

774: l_object_version_number NUMBER;
775:
776: PROCEDURE Update_Addr(addr_rec addr_c%ROWTYPE , reladdr_rec reladdr_rec_c%ROWTYPE , p_rel_person_id NUMBER) AS
777: --Check to see if for this address these two site usages exist.
778: CURSOR site_c (p_party_site_id igs_pe_addr_v.party_site_id%TYPE,
779: p_site_use_code igs_ad_reladdr_int.site_use_code_1%TYPE ) IS
780: SELECT site_use_type,party_site_use_id,last_update_date
781: FROM hz_party_site_uses
782: WHERE party_site_id = p_party_site_id AND

Line 1274: FROM igs_pe_addr_v pe

1270: WHERE mi.interface_relations_id = p_interface_relations_id
1271: AND mi.match_ind IS NULL
1272: AND mi.status = '2'
1273: AND EXISTS ( SELECT 1
1274: FROM igs_pe_addr_v pe
1275: WHERE UPPER(mi.addr_line_1) = UPPER(pe.addr_line_1)
1276: AND NVL(UPPER(mi.addr_line_2),'NulL') = NVL(UPPER(pe.addr_line_2),'NulL')
1277: AND NVL(UPPER(mi.addr_line_3),'NulL') = NVL(UPPER(pe.addr_line_3),'NulL')
1278: AND NVL(UPPER(mi.addr_line_4),'NulL') = NVL(UPPER(pe.addr_line_4),'NulL')