APPS.IGF_SL_CL_VALIDATION dependencies on IGF_SL_LOR

Line 333: igf_sl_lor lor,

329: fcat.alt_loan_code,
330: TRUNC(fabase.coa_f) coa_f,
331: loans.external_loan_id_txt
332: FROM igf_sl_loans loans,
333: igf_sl_lor lor,
334: igf_aw_award awd,
335: igf_aw_fund_mast fmast,
336: igf_aw_fund_cat fcat,
337: igf_ap_fa_base_rec fabase,

Line 543: p_prc_type_code igf_sl_lor.prc_type_code%TYPE)

539: END unmetneed;
540:
541: PROCEDURE cl_alt_borr_cosig_validation (p_loan_number igf_sl_loans.loan_number%TYPE,
542: p_loan_catg VARCHAR2,
543: p_prc_type_code igf_sl_lor.prc_type_code%TYPE)
544: AS
545: /***************************************************************
546: Created By : bvisvana
547: Date Created By : 02-June-2005

Line 569: igf_sl_lor lor,

565: lor.prc_type_code prc_type_code,
566: loans.loan_number loan_number
567: FROM
568: igf_sl_loans loans,
569: igf_sl_lor lor,
570: igf_sl_alt_borw borw
571: WHERE
572: loans.loan_number = p_loan_number AND
573: lor.prc_type_code = p_prc_type_code AND