APPS.ICX_CAT_POPULATE_STATUS_PVT dependencies on PO_QUOTATION_APPROVALS_ALL

Line 99: 5. Just check for the end date in po_quotation_approvals_all. Start_date will be checked by the search code

95: -- Catalog Quotation => CATALOG
96: -- Standard Quotation => CATALOG
97: 3. Just check for the end date in po_line_locations_all. Start_date will be checked by the search code
98: 4. pqa.approval_type IN ('ALL ORDERS','REQUISITIONS') changed to pqa.approval_type IS NOT NULL to accomodate the SIC rules
99: 5. Just check for the end date in po_quotation_approvals_all. Start_date will be checked by the search code
100: 6. Just check for the end date in po_headers_all. Start_date will be checked by the search code
101: */
102:
103: SELECT VALID_FOR_POPULATE

Line 116: po_quotation_approvals_all pqa

112: AND (NVL(ph.approval_required_flag,'N') = 'N' OR
113: (ph.approval_required_flag ='Y' AND
114: EXISTS (SELECT 'current approved effective price break'
115: FROM po_line_locations_all pll,
116: po_quotation_approvals_all pqa
117: WHERE pl.po_line_id = pll.po_line_id
118: AND SYSDATE <= NVL(pll.end_date, SYSDATE+1)
119: AND pqa.line_location_id = pll.line_location_id
120: AND pqa.approval_type IN ('ALL ORDERS','REQUISITIONS')