APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_CL_SETUP_ALL

Line 48: cl_version igf_sl_cl_setup_all.cl_version%TYPE

44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,
47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,
48: cl_version igf_sl_cl_setup_all.cl_version%TYPE
49: );
50:
51: -- procedure for enabling statement level logging
52: PROCEDURE log_to_fnd ( p_v_module IN VARCHAR2,

Line 1043: ,igf_sl_cl_setup_all clset

1039: ,igf_sl_loans loans
1040: ,igf_aw_award_all awd
1041: ,igf_aw_fund_mast_all fmast
1042: ,igf_aw_fund_cat_all fcat
1043: ,igf_sl_cl_setup_all clset
1044: WHERE ((lor.loan_id = cp_n_loan_id) OR cp_n_loan_id IS NULL)
1045: AND loans.loan_id = lor.loan_id
1046: AND awd.award_id = loans.award_id
1047: AND ((awd.base_id = cp_n_base_id) OR cp_n_base_id IS NULL)

Line 1664: l_v_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

1660: l_v_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;
1661: l_v_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
1662: l_v_file_crea_date VARCHAR2(8);
1663: l_v_file_crea_time VARCHAR2(6);
1664: l_v_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1665: l_v_source_name igf_ap_school_opeid_v.meaning%TYPE;
1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1667: l_v_recipient_name igf_sl_servicer.description%TYPE;
1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;