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_AW_AWD_DISB_PKG dependencies on IGF_SL_LOANS_ALL

Line 67: FROM IGF_SL_LOANS_ALL sl

63: l_max_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE;
64:
65: CURSOR loans_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
66: SELECT sl.ROWID, sl.*
67: FROM IGF_SL_LOANS_ALL sl
68: WHERE sl.award_id = cp_award_id;
69: loans_rec loans_cur%ROWTYPE;
70:
71: CURSOR pell_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

Line 902: ,igf_sl_loans_all lar

898: ,lar.loan_status
899: ,lor.prc_type_code
900: ,lor.cl_rec_status
901: FROM igf_sl_lor_all lor
902: ,igf_sl_loans_all lar
903: WHERE lor.loan_id = lar.loan_id
904: AND lar.award_id = cp_n_award_id;
905:
906: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;

Line 909: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,

905:
906: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;
907:
908: CURSOR c_sl_clchsn_dtls (
909: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
910: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE
911: ) IS
912: SELECT chdt.ROWID row_id,chdt.*
913: FROM igf_sl_clchsn_dtls chdt

Line 928: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

924: l_v_message_name fnd_new_messages.message_name%TYPE;
925: l_b_return_status BOOLEAN;
926: l_n_award_id igf_aw_award_all.award_id%TYPE;
927: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
928: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
929: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
930: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
931: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
932: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

Line 932: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

928: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
929: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
930: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
931: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
932: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
933: BEGIN
934: IF p_deleting THEN
935: OPEN c_aw_awd_disb (cp_rowid => p_rowid);
936: FETCH c_aw_awd_disb INTO l_n_award_id,l_n_disb_num;

Line 1028: ,igf_sl_loans_all lar

1024: ,lar.loan_status
1025: ,lor.prc_type_code
1026: ,lor.cl_rec_status
1027: FROM igf_sl_lor_all lor
1028: ,igf_sl_loans_all lar
1029: WHERE lor.loan_id = lar.loan_id
1030: AND lar.award_id = cp_n_award_id;
1031:
1032: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;

Line 1040: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

1036: l_b_return_status BOOLEAN;
1037: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
1038: l_v_rowid ROWID;
1039: l_n_award_id igf_aw_award_all.award_id%TYPE;
1040: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1041: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1042: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
1043: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
1044: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

Line 1044: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

1040: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1041: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1042: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
1043: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
1044: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1045:
1046: CURSOR c_sl_clchsn_dtls (
1047: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
1048: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE

Line 1047: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,

1043: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
1044: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1045:
1046: CURSOR c_sl_clchsn_dtls (
1047: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
1048: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1049: ) IS
1050: SELECT chdt.ROWID row_id,chdt.*
1051: FROM igf_sl_clchsn_dtls chdt