APPS.IGF_SL_CL_VALIDATION dependencies on IGF_SL_REQD_FIELDS

Line 105: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,

101: END log_to_fnd;
102:
103: FUNCTION check_for_reqd(
104: p_loan_number igf_sl_loans.loan_number%TYPE,
105: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
106: p_field_name igf_sl_reqd_fields.field_name%TYPE,
107: p_field_value VARCHAR2,
108: p_prc_type_code igf_sl_reqd_fields.prc_type_code%TYPE
109: ) RETURN BOOLEAN

Line 106: p_field_name igf_sl_reqd_fields.field_name%TYPE,

102:
103: FUNCTION check_for_reqd(
104: p_loan_number igf_sl_loans.loan_number%TYPE,
105: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
106: p_field_name igf_sl_reqd_fields.field_name%TYPE,
107: p_field_value VARCHAR2,
108: p_prc_type_code igf_sl_reqd_fields.prc_type_code%TYPE
109: ) RETURN BOOLEAN
110: AS

Line 108: p_prc_type_code igf_sl_reqd_fields.prc_type_code%TYPE

104: p_loan_number igf_sl_loans.loan_number%TYPE,
105: p_loan_catg igf_sl_reqd_fields.loan_type%TYPE,
106: p_field_name igf_sl_reqd_fields.field_name%TYPE,
107: p_field_value VARCHAR2,
108: p_prc_type_code igf_sl_reqd_fields.prc_type_code%TYPE
109: ) RETURN BOOLEAN
110: AS
111:
112: /***************************************************************

Line 130: SELECT DISTINCT status from igf_sl_reqd_fields lrf

126:
127: -- Value of Spec Version in Table is same as Loan Type sent as Parameter
128:
129: CURSOR cur_reqd IS
130: SELECT DISTINCT status from igf_sl_reqd_fields lrf
131: WHERE lrf.loan_type = p_loan_catg
132: AND lrf.field_name = p_field_name
133: AND lrf.spec_version = p_cl_version
134: -- AND lrf.transaction_type = '@1'