APPS.ICX_CAT_UTIL_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 983: FROM po_line_locations_all pll, po_quotation_approvals_all pqa

979: AND (NVL(ph.approval_required_flag, 'N') = 'N'
980: OR
981: (ph.approval_required_flag = 'Y' AND
982: EXISTS (SELECT 'current approved effective price break'
983: FROM po_line_locations_all pll, po_quotation_approvals_all pqa
984: WHERE pl.po_line_id = pll.po_line_id
985: AND SYSDATE BETWEEN NVL(pll.start_date, SYSDATE-1) AND
986: NVL(pll.end_date, SYSDATE+1)
987: AND pqa.line_location_id = pll.line_location_id