APPS.IGF_DB_CL_ROSTER dependencies on IGF_SL_LOANS_ALL

Line 261: CURSOR cur_lor_data (cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS

257: header_parameter_rec c_get_header_parameters%ROWTYPE;
258: trailer_parameter_rec c_get_trailer_parameters%ROWTYPE;
259: roster_logs_rec cur_roster_logs%ROWTYPE;
260:
261: CURSOR cur_lor_data (cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS
262: SELECT lor.ROWID row_id, lor.*
263: FROM IGF_SL_LOR_ALL lor,
264: IGF_SL_LOANS_ALL loans
265: WHERE loans.loan_id = lor.loan_id

Line 264: IGF_SL_LOANS_ALL loans

260:
261: CURSOR cur_lor_data (cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS
262: SELECT lor.ROWID row_id, lor.*
263: FROM IGF_SL_LOR_ALL lor,
264: IGF_SL_LOANS_ALL loans
265: WHERE loans.loan_id = lor.loan_id
266: AND loans.loan_number = cp_loan_number;
267:
268: rec_lor_data cur_lor_data%ROWTYPE;

Line 971: PROCEDURE log_start(p_loan_number igf_sl_loans_all.loan_number%TYPE,

967: AND status = 'N'
968: FOR UPDATE OF status NOWAIT;
969:
970:
971: PROCEDURE log_start(p_loan_number igf_sl_loans_all.loan_number%TYPE,
972: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
973: AS
974: l_msg_str_0 VARCHAR2(1000);
975: BEGIN

Line 1055: FROM igf_aw_awd_disb disb,igf_sl_loans_all loans

1051: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
1052: IS
1053: SELECT
1054: disb.*
1055: FROM igf_aw_awd_disb disb,igf_sl_loans_all loans
1056: WHERE
1057: NVL(loans.external_loan_id_txt, loans.loan_number) = l_loan_number AND
1058: disb.award_id = loans.award_id AND
1059: disb.disb_num = l_disb_num

Line 1073: igf_sl_loans_all loans,igf_sl_lor_all lor

1069: IN
1070: (
1071: SELECT base.ci_cal_type,base.ci_sequence_number, lor.relationship_cd
1072: FROM igf_ap_fa_base_rec_all base, igf_aw_award_all awd,
1073: igf_sl_loans_all loans,igf_sl_lor_all lor
1074: WHERE base.base_id = awd.base_id
1075: AND awd.award_id = loans.award_id
1076: AND loans.loan_id = lor.loan_id
1077: AND awd.award_id = p_award_id