APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_PE_PERSON_BASE_V

Line 177: l_previous_person_id igs_pe_person_base_v.person_id%TYPE;

173:
174: l_research_std cur_research_std%ROWTYPE;
175:
176: l_comdate igs_he_ex_rn_dat_fd.value%TYPE;
177: l_previous_person_id igs_pe_person_base_v.person_id%TYPE;
178:
179: -- Local variable holds C(created dlhe), U(Updated dlhe), E(Record Exists with an open qual period), F for field validation failed
180: l_cre_upd_dlhe VARCHAR2(1);
181:

Line 848: CURSOR cur_person_num (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

844:
845: l_he_ad_dtl c_he_ad_dtl%ROWTYPE;
846:
847: -- Get the person number for reporting into log file
848: CURSOR cur_person_num (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
849: SELECT person_number
850: FROM igs_pe_person_base_v
851: WHERE person_id = cp_person_id;
852:

Line 850: FROM igs_pe_person_base_v

846:
847: -- Get the person number for reporting into log file
848: CURSOR cur_person_num (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
849: SELECT person_number
850: FROM igs_pe_person_base_v
851: WHERE person_id = cp_person_id;
852:
853: l_person_number igs_pe_person_base_v.person_number%TYPE;
854:

Line 853: l_person_number igs_pe_person_base_v.person_number%TYPE;

849: SELECT person_number
850: FROM igs_pe_person_base_v
851: WHERE person_id = cp_person_id;
852:
853: l_person_number igs_pe_person_base_v.person_number%TYPE;
854:
855: -- QUAL1 and QUAL2 out parameter/local variables
856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;