APPS.IGS_GR_PRC_GAC dependencies on IGS_PE_PERSON_BASE_V

Line 264: FROM IGS_PE_PERSON_BASE_V pe

260: DECLARE
261: v_letter_number NUMBER;
262: CURSOR c_pe IS
263: SELECT (ASCII(UPPER(pe.last_name)) - 65)
264: FROM IGS_PE_PERSON_BASE_V pe
265: WHERE pe.person_id = p_person_id;
266: BEGIN
267: OPEN c_pe;
268: FETCH c_pe INTO v_letter_number;

Line 347: FROM igs_pe_person_base_v

343:
344: -- Added the following coursor to get the Person Number. Bug# 2690151
345: CURSOR get_person_num IS
346: SELECT person_number
347: FROM igs_pe_person_base_v
348: WHERE person_id = p_person_id;
349: l_person_number igs_pe_person_base_v.person_number%TYPE := NULL;
350: BEGIN
351: IGS_GR_AWD_CRMN_PKG.INSERT_ROW(

Line 349: l_person_number igs_pe_person_base_v.person_number%TYPE := NULL;

345: CURSOR get_person_num IS
346: SELECT person_number
347: FROM igs_pe_person_base_v
348: WHERE person_id = p_person_id;
349: l_person_number igs_pe_person_base_v.person_number%TYPE := NULL;
350: BEGIN
351: IGS_GR_AWD_CRMN_PKG.INSERT_ROW(
352: X_ROWID => lv_rowid,
353: X_GAC_ID => lv_id,