DBA Data[Home] [Help]

APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on FV_TOP_EXCLUSION_CRITERIA_ALL

Line 153: FROM FV_TOP_EXCLUSION_CRITERIA_ALL FVTOPEC

149: ,p_vendor_site_id_csr NUMBER
150: ,p_payment_date_csr DATE)
151: IS
152: SELECT '1'
153: FROM FV_TOP_EXCLUSION_CRITERIA_ALL FVTOPEC
154: WHERE FVTOPEC.set_of_books_id = p_sob_id_csr
155: AND (FVTOPEC.payment_reason_code = NVL(p_payment_reason_csr,'-999')
156: OR FVTOPEC.vendor_type_code = NVL(p_vendor_type_csr,'-999')
157: OR (FVTOPEC.vendor_id = p_vendor_id_csr