APPS.IGF_SL_GEN dependencies on IGS_PE_PERSON_ID_TYP

Line 888: cp_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE

884: (reverse chronological order - newest change first)
885: **************************************************************/
886: CURSOR c_get_ssn (
887: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
888: cp_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE
889: )
890: IS
891: SELECT api.api_person_id_uf ssn,
892: api.person_id_type,

Line 896: igs_pe_person_id_typ pid

892: api.person_id_type,
893: api.start_dt,
894: api.end_dt
895: FROM igs_pe_alt_pers_id api,
896: igs_pe_person_id_typ pid
897: WHERE api.pe_person_id = cp_person_id
898: AND api.person_id_type = pid.person_id_type
899: AND pid.s_person_id_type = cp_person_id_type --
900: AND SYSDATE BETWEEN api.start_dt AND NVL(api.end_dt,SYSDATE);

Line 974: cp_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE

970:
971:
972: CURSOR c_get_lic_num (
973: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
974: cp_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE
975: )
976: IS
977: SELECT api.api_person_id,
978: api.region_cd,

Line 984: igs_pe_person_id_typ pid

980: api.start_dt,
981: api.end_dt,
982: pid.s_person_id_type
983: FROM igs_pe_alt_pers_id api,
984: igs_pe_person_id_typ pid
985: WHERE api.pe_person_id = cp_person_id
986: AND api.person_id_type = pid.person_id_type
987: AND pid.s_person_id_type = cp_person_id_type
988: AND SYSDATE BETWEEN api.start_dt AND NVL(api.end_dt,SYSDATE);