APPS.IGS_AD_IMP_013 dependencies on IGS_PE_PERSON_BASE_V

Line 481: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

477: p_error_code OUT NOCOPY VARCHAR2,
478: p_hr_installed IN VARCHAR2
479: )
480: IS
481: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
482:
483: CURSOR system_type_cur(cp_person_type_code igs_pe_type_int.person_type_code%TYPE)
484: IS
485: SELECT system_type

Line 490: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE)

486: FROM igs_pe_person_types
487: WHERE person_type_code = cp_person_type_code
488: AND closed_ind = 'N';
489:
490: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE)
491: IS
492: SELECT birth_date
493: FROM igs_pe_person_base_v
494: WHERE person_id = cp_person_id;

Line 493: FROM igs_pe_person_base_v

489:
490: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE)
491: IS
492: SELECT birth_date
493: FROM igs_pe_person_base_v
494: WHERE person_id = cp_person_id;
495:
496: CURSOR chk_lkup_code(l_lookup_code igs_lookup_values.lookup_code%TYPE,
497: l_lookup_type igs_lookup_values.lookup_type%TYPE,