APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on FV_TOP_EXCLUSION_CRITERIA

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

Line 181: FROM fv_top_exclusion_criteria

177: CURSOR accounts_criteria_csr(p_payment_date_csr DATE
178: ,p_sob_id_csr NUMBER)
179: IS
180: SELECT concatenated_segments_low , concatenated_segments_high
181: FROM fv_top_exclusion_criteria
182: WHERE (concatenated_segments_low IS NOT NULL
183: AND concatenated_segments_high IS NOT NULL )
184: AND set_of_books_id = p_sob_id_csr
185: AND NVL(effective_start_date ,p_payment_date_csr) <= p_payment_date_csr

Line 259: -- check excluded accounts in fv_top_exclusion_criteria table

255: END IF ;
256:
257: CLOSE offset_exclusion_csr ;
258:
259: -- check excluded accounts in fv_top_exclusion_criteria table
260:
261: OPEN invoice_dist_csr;
262: LOOP
263: FETCH invoice_dist_csr INTO invoice_dist_rec ;