APPS.ICX_CAT_UTIL_PVT dependencies on PO_QUOTATION_APPROVALS_ALL

Line 1061: FROM po_line_locations_all pll, po_quotation_approvals_all pqa

1057: AND (NVL(ph.approval_required_flag, 'N') = 'N'
1058: OR
1059: (ph.approval_required_flag = 'Y' AND
1060: EXISTS (SELECT 'current approved effective price break'
1061: FROM po_line_locations_all pll, po_quotation_approvals_all pqa
1062: WHERE pl.po_line_id = pll.po_line_id
1063: AND SYSDATE BETWEEN NVL(pll.start_date, SYSDATE-1) AND
1064: NVL(pll.end_date, SYSDATE+1)
1065: AND pqa.line_location_id = pll.line_location_id