DBA Data[Home] [Help]

APPS.IGF_AW_GEN dependencies on IGF_DB_AWD_DISB_DTL_ALL

Line 367: FROM igf_db_awd_disb_dtl_all

363: )
364: IS
365: SELECT
366: SUM(DECODE(DISB_ACTIVITY,'D',DISB_NET_AMT,'A',DISB_ADJ_AMT,'Q',0)) net_total
367: FROM igf_db_awd_disb_dtl_all
368: WHERE award_id =p_award_id AND disb_num = p_disb_num AND sf_status in('R','P','E');
369:
370: r_get_net_total c_get_net_total%ROWTYPE;
371: