DBA Data[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGF_AW_AWARD_V

Line 130: award_rec igf_aw_award_v%ROWTYPE;

126: -- FA 134
127:
128: -- FA 134
129:
130: award_rec igf_aw_award_v%ROWTYPE;
131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;
132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:

Line 741: p_base_id IN igf_aw_award_v.base_id%TYPE)

737: END log_message;
738:
739:
740: FUNCTION ret_loan_number(p_loan_seq_number IN igf_sl_loans.seq_num%TYPE,
741: p_base_id IN igf_aw_award_v.base_id%TYPE)
742: RETURN VARCHAR2
743: IS
744: /***************************************************************
745: Created By : mesriniv

Line 2614: FROM igf_aw_award_v awdv

2610: performance.
2611: *******************************************************************************/
2612: CURSOR cur_awards_recs (p_award_id number, p_fund_id number, p_base_id number) IS
2613: SELECT awdv.*
2614: FROM igf_aw_award_v awdv
2615: WHERE awdv.sys_fund_type ='LOAN'
2616: AND awdv.ci_cal_type = p_ci_cal_type
2617: AND awdv.ci_sequence_number = p_ci_sequence_number
2618: AND awdv.award_id = NVL(p_award_id, awdv.award_id)