APPS.IGS_GR_GEN_002 dependencies on IGS_PE_PERSON_BASE_V

Line 213: CURSOR get_person_num(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

209: course_cd = cp_course_cd;
210: rec_spaaa cur_spaaa%ROWTYPE;
211:
212: -- Added the following coursor to get the Person Number. Bug# 2690151
213: CURSOR get_person_num(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
214: SELECT person_number
215: FROM igs_pe_person_base_v
216: WHERE person_id = cp_person_id;
217: l_person_number VARCHAR2(500) := NULL;

Line 215: FROM igs_pe_person_base_v

211:
212: -- Added the following coursor to get the Person Number. Bug# 2690151
213: CURSOR get_person_num(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
214: SELECT person_number
215: FROM igs_pe_person_base_v
216: WHERE person_id = cp_person_id;
217: l_person_number VARCHAR2(500) := NULL;
218: l_log_person_id VARCHAR2(250);
219: l_chk_hold VARCHAR2(250);

Line 1557: FROM igs_pe_person_base_v

1553: EXCEPTION WHEN OTHERS THEN
1554: DECLARE
1555: CURSOR cur_get_person_num (cp_person_id NUMBER)IS
1556: SELECT person_number
1557: FROM igs_pe_person_base_v
1558: WHERE person_id = cp_person_id;
1559: rec_get_person_num cur_get_person_num%ROWTYPE;
1560: l_log VARCHAR2(4000);
1561: BEGIN