APPS.IGF_SL_GEN dependencies on IGS_PE_EIT

Line 1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE

1024:
1025:
1026: CURSOR c_get_reg_num (
1027: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE
1029: )
1030: IS
1031: SELECT document_num
1032: FROM igs_pe_eit_perm_res_v

Line 1032: FROM igs_pe_eit_perm_res_v

1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE
1029: )
1030: IS
1031: SELECT document_num
1032: FROM igs_pe_eit_perm_res_v
1033: WHERE perm_res_cntry = cp_perm_res_cntry
1034: AND person_id = cp_person_id
1035: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1036:

Line 1041: cp_information_type igs_pe_eit.information_type%TYPE

1037: l_get_reg_num VARCHAR2(150);
1038:
1039: CURSOR c_get_res_state (
1040: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1041: cp_information_type igs_pe_eit.information_type%TYPE
1042: )
1043: IS
1044: SELECT pei_information1 state_code,
1045: start_date

Line 1046: FROM igs_pe_eit

1042: )
1043: IS
1044: SELECT pei_information1 state_code,
1045: start_date
1046: FROM igs_pe_eit
1047: WHERE person_id = cp_person_id
1048: AND information_type = cp_information_type
1049: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1050:

Line 1062: igs_pe_eit_restatus_v pct

1058: IS
1059: SELECT lkup.tag,
1060: pct.restatus_code
1061: FROM igs_lookup_values lkup,
1062: igs_pe_eit_restatus_v pct
1063: WHERE lkup.lookup_type = cp_lookup_type
1064: AND lkup.lookup_code = pct.restatus_code
1065: AND pct.person_id = cp_person_id
1066: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE)