eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_CREATE_CHG dependencies on IGF_SL_CL_RESP_R1_ALL

Line 62: FROM igf_sl_cl_resp_r1_all resp

58:
59: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
60: SELECT resp.loan_per_begin_date
61: ,resp.loan_per_end_date
62: FROM igf_sl_cl_resp_r1_all resp
63: WHERE resp.loan_number = cp_v_loan_number
64: AND resp.cl_rec_status IN ('B','G')
65: AND resp.prc_type_code IN ('GO','GP')
66: AND resp.cl_version_code = 'RELEASE-4'

Line 76: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;

72: c_igf_sl_clchsn_dtls ref_CurclchsnTyp;
73:
74: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
75:
76: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
77: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
78: l_d_res_loan_per_begin_dt igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
79: l_d_res_loan_per_end_dt igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
80: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

Line 77: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;

73:
74: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
75:
76: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
77: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
78: l_d_res_loan_per_begin_dt igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
79: l_d_res_loan_per_end_dt igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
80: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

Line 78: l_d_res_loan_per_begin_dt igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;

74: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
75:
76: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
77: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
78: l_d_res_loan_per_begin_dt igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
79: l_d_res_loan_per_end_dt igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
80: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
82: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;

Line 79: l_d_res_loan_per_end_dt igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;

75:
76: l_d_loan_per_begin_date igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
77: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
78: l_d_res_loan_per_begin_dt igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
79: l_d_res_loan_per_end_dt igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
80: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
82: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
83: l_n_award_id igf_aw_award_all.award_id%TYPE;

Line 770: FROM igf_sl_cl_resp_r1_all resp

766:
767: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
768: SELECT resp.anticip_compl_date
769: ,resp.grade_level_code
770: FROM igf_sl_cl_resp_r1_all resp
771: WHERE resp.loan_number = cp_v_loan_number
772: AND resp.cl_rec_status IN ('B','G')
773: AND resp.prc_type_code IN ('GO','GP')
774: AND resp.cl_version_code = 'RELEASE-4'

Line 782: l_d_resp_anticip_compl_dt igf_sl_cl_resp_r1_all.anticip_compl_date%TYPE;

778: c_igf_sl_clchsn_dtls ref_CurclchsnTyp;
779:
780: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
781:
782: l_d_resp_anticip_compl_dt igf_sl_cl_resp_r1_all.anticip_compl_date%TYPE;
783: l_d_lor_anticip_compl_dt igf_sl_lor_all.anticip_compl_date%TYPE;
784: l_v_resp_grade_level_cd igf_sl_lor_all.override_grade_level_code%TYPE;
785: l_v_ovr_grade_level_cd igf_sl_lor_all.override_grade_level_code%TYPE;
786: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

Line 1483: FROM igf_sl_cl_resp_r1_all resp

1479: AND NVL(adisb.fund_status,'N') = 'Y';
1480:
1481: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
1482: SELECT resp.guarantee_amt
1483: FROM igf_sl_cl_resp_r1_all resp
1484: WHERE resp.loan_number = cp_v_loan_number
1485: AND resp.cl_rec_status IN ('B','G')
1486: AND resp.prc_type_code IN ('GO','GP')
1487: AND resp.cl_version_code = 'RELEASE-4'

Line 1508: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;

1504: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1507: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1508: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
1509: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;
1510: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;
1511:
1512: e_valid_edits EXCEPTION;

Line 2878: FROM igf_sl_cl_resp_r1_all resp_r1

2874: ) IS
2875: SELECT resp_r8.disb_date
2876: ,resp_r8.disb_gross_amt
2877: ,resp_r8.disb_hold_rel_ind
2878: FROM igf_sl_cl_resp_r1_all resp_r1
2879: ,igf_sl_cl_resp_r8_all resp_r8
2880: WHERE resp_r1.loan_number = cp_v_loan_number
2881: AND resp_r1.cl_rec_status IN ('B','G')
2882: AND resp_r1.prc_type_code IN ('GO','GP')