APPS.IGF_AW_AWD_DISB_PKG dependencies on IGF_SL_LOR_ALL

Line 901: FROM igf_sl_lor_all lor

897: SELECT lar.loan_number
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:

Line 930: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;

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;
933: BEGIN
934: IF p_deleting THEN

Line 931: l_v_prc_type_code igf_sl_lor_all.prc_type_code%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;
933: BEGIN
934: IF p_deleting THEN
935: OPEN c_aw_awd_disb (cp_rowid => p_rowid);

Line 1027: FROM igf_sl_lor_all lor

1023: SELECT lar.loan_number
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:

Line 1042: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%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;
1045:
1046: CURSOR c_sl_clchsn_dtls (

Line 1043: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;

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;
1045:
1046: CURSOR c_sl_clchsn_dtls (
1047: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,