DBA Data[Home] [Help]

APPS.IGF_GR_RFMS_DISB_ORIG dependencies on IGF_AW_AWD_DISB_ALL

Line 111: FROM igf_aw_awd_disb_all disb

107: AND rfms.attending_campus_id = NVL(cp_attending_pell, rfms.attending_campus_id)
108: AND rfmd.disb_ack_act_status = 'R'
109: AND rfmd.origination_id = rfms.origination_id
110: AND rfmd.disb_ref_num IN (SELECT disb.disb_num
111: FROM igf_aw_awd_disb_all disb
112: WHERE disb.trans_type IN ('A')
113: AND disb.award_id = rfms.award_id
114: AND g_trans_type IN ('A','P')
115: UNION ALL

Line 117: FROM igf_aw_awd_disb_all disb

113: AND disb.award_id = rfms.award_id
114: AND g_trans_type IN ('A','P')
115: UNION ALL
116: SELECT disb.disb_num
117: FROM igf_aw_awd_disb_all disb
118: WHERE disb.trans_type IN ('P')
119: AND disb.award_id = rfms.award_id
120: AND disb.disb_date <= DECODE(setup.funding_method,'J',TRUNC(SYSDATE) + 7,'A',TRUNC(SYSDATE) + 30)
121: AND g_trans_type = 'P'