APPS.AP_TP_STMT_PKG dependencies on AP_HOLDS

Line 119: gc_validate_inv := gc_validate_inv||' FROM ap_holds h';

115: gc_validate_inv := gc_validate_inv||' AND i.validation_request_id IS NULL';
116: gc_validate_inv := gc_validate_inv||' AND ( ';
117: gc_validate_inv := gc_validate_inv||' NOT EXISTS (';
118: gc_validate_inv := gc_validate_inv||' SELECT ''Unreleased Hold exists''';
119: gc_validate_inv := gc_validate_inv||' FROM ap_holds h';
120: gc_validate_inv := gc_validate_inv||' WHERE h.invoice_id = i.invoice_id';
121: gc_validate_inv := gc_validate_inv||' AND h.hold_lookup_code IN';
122: gc_validate_inv := gc_validate_inv||' (''QTY ORD'', ''QTY REC'', ''AMT ORD'', ''AMT REC'',';
123: gc_validate_inv := gc_validate_inv||' ''QUALITY'', ''PRICE'', ''TAX DIFFERENCE'',';

Line 184: FROM ap_holds h

180: AND d.posted_flag IN ('N', 'Y') --Included correct validation status , Bug9397505
181: AND i.validation_request_id IS NULL
182: AND ( NOT EXISTS (
183: SELECT 'Unreleased Hold exists'
184: FROM ap_holds h
185: WHERE h.invoice_id = i.invoice_id
186: AND h.hold_lookup_code IN
187: ('QTY ORD', 'QTY REC', 'AMT ORD', 'AMT REC',
188: 'QUALITY', 'PRICE', 'TAX DIFFERENCE',