APPS.IGF_SL_GEN dependencies on IGF_AW_AWD_DISB

Line 686: p_disb_num IN igf_aw_awd_disb.disb_num%TYPE)

682: END get_cl_batch_details;
683:
684: -- Function to return the Disbursement Date
685: FUNCTION get_disb_date(p_loan_id IN igf_sl_loans.loan_id%TYPE,
686: p_disb_num IN igf_aw_awd_disb.disb_num%TYPE)
687: RETURN DATE
688: AS
689: /*************************************************************
690: Created By : pkpatel

Line 702: FROM igf_sl_loans isl, igf_aw_awd_disb iaad

698: ***************************************************************/
699: /* Declared the CURSOR to select the disbursement date for the particular loan ID and Disbursement Number */
700: CURSOR c_disb_date IS
701: SELECT iaad.disb_date
702: FROM igf_sl_loans isl, igf_aw_awd_disb iaad
703: WHERE isl.loan_id = p_loan_id
704: AND iaad.disb_num = p_disb_num
705: AND isl.award_id = iaad.award_id;
706:

Line 707: l_disb_date IGF_AW_AWD_DISB.disb_date%TYPE; --variable declared to hold the Disbursement date

703: WHERE isl.loan_id = p_loan_id
704: AND iaad.disb_num = p_disb_num
705: AND isl.award_id = iaad.award_id;
706:
707: l_disb_date IGF_AW_AWD_DISB.disb_date%TYPE; --variable declared to hold the Disbursement date
708: BEGIN
709: OPEN c_disb_date;
710: FETCH c_disb_date INTO l_disb_date;
711: IF c_disb_date%notfound THEN