APPS.IGF_SL_DL_VALIDATION dependencies on IGF_SL_REQD_FIELDS

Line 71: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,

67: isir_info_rec cur_isir_info%ROWTYPE;
68:
69:
70: FUNCTION check_for_reqd(p_loan_number igf_sl_loans.loan_number%TYPE,
71: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
72: p_field_name igf_sl_reqd_fields.field_name%TYPE,
73: p_field_value VARCHAR2
74: ) RETURN BOOLEAN
75: AS

Line 72: p_field_name igf_sl_reqd_fields.field_name%TYPE,

68:
69:
70: FUNCTION check_for_reqd(p_loan_number igf_sl_loans.loan_number%TYPE,
71: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
72: p_field_name igf_sl_reqd_fields.field_name%TYPE,
73: p_field_value VARCHAR2
74: ) RETURN BOOLEAN
75: AS
76: /*************************************************************

Line 93: SELECT status from igf_sl_reqd_fields lrf

89: lv_data_reqd fnd_lookups.lookup_code%TYPE;
90: lv_data_recomm fnd_lookups.lookup_code%TYPE;
91:
92: CURSOR cur_reqd IS
93: SELECT status from igf_sl_reqd_fields lrf
94: WHERE lrf.spec_version = p_dl_version
95: AND lrf.loan_type = p_loan_catg
96: AND lrf.field_name = p_field_name;
97:

Line 337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;

333:
334: (reverse chronological order - newest change first)
335: ***************************************************************/
336:
337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;
338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;