APPS.IGS_AD_IMP_009 dependencies on IGS_AD_IMP_MATCHES_PPA_V

Line 978: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_ppa_v.interface_id%TYPE,

974: l_debug_str VARCHAR2(2000);
975: l_enable_log VARCHAR2(1);
976: l_request_id NUMBER;
977:
978: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_ppa_v.interface_id%TYPE,
979: cp_c_addr_type igs_ad_imp_matches_ppa_v.addr_type%TYPE,
980: cp_c_person_id_type igs_ad_imp_matches_ppa_v.person_id_type%TYPE )IS
981: SELECT *
982: FROM igs_ad_imp_matches_ppa_v

Line 979: cp_c_addr_type igs_ad_imp_matches_ppa_v.addr_type%TYPE,

975: l_enable_log VARCHAR2(1);
976: l_request_id NUMBER;
977:
978: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_ppa_v.interface_id%TYPE,
979: cp_c_addr_type igs_ad_imp_matches_ppa_v.addr_type%TYPE,
980: cp_c_person_id_type igs_ad_imp_matches_ppa_v.person_id_type%TYPE )IS
981: SELECT *
982: FROM igs_ad_imp_matches_ppa_v
983: WHERE interface_id = cp_d_interface_id

Line 980: cp_c_person_id_type igs_ad_imp_matches_ppa_v.person_id_type%TYPE )IS

976: l_request_id NUMBER;
977:
978: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_ppa_v.interface_id%TYPE,
979: cp_c_addr_type igs_ad_imp_matches_ppa_v.addr_type%TYPE,
980: cp_c_person_id_type igs_ad_imp_matches_ppa_v.person_id_type%TYPE )IS
981: SELECT *
982: FROM igs_ad_imp_matches_ppa_v
983: WHERE interface_id = cp_d_interface_id
984: AND (addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y')

Line 982: FROM igs_ad_imp_matches_ppa_v

978: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_ppa_v.interface_id%TYPE,
979: cp_c_addr_type igs_ad_imp_matches_ppa_v.addr_type%TYPE,
980: cp_c_person_id_type igs_ad_imp_matches_ppa_v.person_id_type%TYPE )IS
981: SELECT *
982: FROM igs_ad_imp_matches_ppa_v
983: WHERE interface_id = cp_d_interface_id
984: AND (addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y')
985: AND (person_id_type = cp_c_person_id_type OR person_id_type IS NULL);
986: