APPS.IGS_AD_IMP_007 dependencies on IGS_PE_SRC_TYPES_ALL

Line 1915: CURSOR source_type_cur(cp_source_type igs_pe_src_types_all.source_type%TYPE) Is

1911: AND api_person_id = api_rec.alternate_id
1912: AND UPPER(person_id_type) = UPPER(api_rec.person_id_type)
1913: AND TRUNC(start_dt) = TRUNC(api_rec.start_dt);
1914:
1915: CURSOR source_type_cur(cp_source_type igs_pe_src_types_all.source_type%TYPE) Is
1916: SELECT source_type_id
1917: FROM igs_pe_src_types_all
1918: WHERE source_type = cp_source_type;
1919:

Line 1917: FROM igs_pe_src_types_all

1913: AND TRUNC(start_dt) = TRUNC(api_rec.start_dt);
1914:
1915: CURSOR source_type_cur(cp_source_type igs_pe_src_types_all.source_type%TYPE) Is
1916: SELECT source_type_id
1917: FROM igs_pe_src_types_all
1918: WHERE source_type = cp_source_type;
1919:
1920: check_dur_rec check_dur_cur%ROWTYPE;
1921: lnDupExist VARCHAR2(1);