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_DB_CL_ROSTER dependencies on IGF_SL_LOR_ALL

Line 263: FROM IGF_SL_LOR_ALL lor,

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
266: AND loans.loan_number = cp_loan_number;
267:

Line 270: lv_esign_roster_data igf_sl_lor_all.esign_src_typ_cd%TYPE;

266: AND loans.loan_number = cp_loan_number;
267:
268: rec_lor_data cur_lor_data%ROWTYPE;
269:
270: lv_esign_roster_data igf_sl_lor_all.esign_src_typ_cd%TYPE;
271:
272: BEGIN
273:
274: -- Check for a proper header

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