DBA Data[Home] [Help]

APPS.AP_PREPAY_TRAK_REP_TURK_PKG dependencies on AP_VIEW_PREPAYS_FR_PREPAY_V

Line 95: FROM ap_view_prepays_fr_prepay_v AVPFPV

91: BEGIN
92: IF prepay_amount_remaining =0 THEN
93: SELECT MAX(AVPFPV.accounting_date)
94: INTO lc_closing_date
95: FROM ap_view_prepays_fr_prepay_v AVPFPV
96: WHERE AVPFPV.prepay_id= prepay_inv_num
97: AND AVPFPV.prepay_line_number= prepay_line_number_param ;
98: ELSIF prepay_amount_remaining IS NULL OR prepay_amount_remaining>0 THEN
99: RETURN(NULL);