APPS.IGR_IMP_003 dependencies on IGS_PE_PERSON_BASE_V

Line 425: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

421: -------------------------Variable Declarations-------------------------------------------------------
422: lv_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
423:
424: lv_exist varchar2(2000);
425: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
426:
427: l_error_text VARCHAR2(2000);
428: -------------------------End Variable Declarations-------------------------------------------------------
429:

Line 432: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS

428: -------------------------End Variable Declarations-------------------------------------------------------
429:
430: ------------------------------------Cursor Declarations----------------------------------------------
431: /*cursor to select Birth Date*/
432: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
433: SELECT birth_date
434: FROM igs_pe_person_base_v
435: WHERE person_id =p_person_id ;
436:

Line 434: FROM igs_pe_person_base_v

430: ------------------------------------Cursor Declarations----------------------------------------------
431: /*cursor to select Birth Date*/
432: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
433: SELECT birth_date
434: FROM igs_pe_person_base_v
435: WHERE person_id =p_person_id ;
436:
437: /*cursor to select inquiry status*/
438: CURSOR c_inquiry_status (cp_inquiry_status igr_i_appl_int.inquiry_status%TYPE) IS

Line 487: igs_pe_person_base_v

483: CURSOR c_registering_person_id (cp_registering_person_id igr_i_appl_int.registering_person_id%TYPE) IS
484: SELECT
485: 'X'
486: FROM
487: igs_pe_person_base_v
488: WHERE
489: person_id = cp_registering_person_id;
490:
491: /*cursor to select education goal */