APPS.IGS_AD_IMP_009 dependencies on IGS_AD_IMP_MATCHES_PP_V

Line 346: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pp_v.interface_id%TYPE,

342: l_debug_str VARCHAR2(2000);
343: l_enable_log VARCHAR2(1);
344: l_request_id NUMBER;
345:
346: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pp_v.interface_id%TYPE,
347: cp_c_person_id_type igs_ad_imp_matches_pp_v.person_id_type%TYPE) IS
348: SELECT *
349: FROM igs_ad_imp_matches_pp_v
350: WHERE interface_id = cp_d_interface_id AND

Line 347: cp_c_person_id_type igs_ad_imp_matches_pp_v.person_id_type%TYPE) IS

343: l_enable_log VARCHAR2(1);
344: l_request_id NUMBER;
345:
346: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pp_v.interface_id%TYPE,
347: cp_c_person_id_type igs_ad_imp_matches_pp_v.person_id_type%TYPE) IS
348: SELECT *
349: FROM igs_ad_imp_matches_pp_v
350: WHERE interface_id = cp_d_interface_id AND
351: ( person_id_type = cp_c_person_id_type OR person_id_type IS NULL );

Line 349: FROM igs_ad_imp_matches_pp_v

345:
346: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pp_v.interface_id%TYPE,
347: cp_c_person_id_type igs_ad_imp_matches_pp_v.person_id_type%TYPE) IS
348: SELECT *
349: FROM igs_ad_imp_matches_pp_v
350: WHERE interface_id = cp_d_interface_id AND
351: ( person_id_type = cp_c_person_id_type OR person_id_type IS NULL );
352:
353: x_lvcExactSelectClause VARCHAR2(32000);