APPS.PO_VAL_HEADERS dependencies on ORG_FREIGHT

Line 2377: WHERE NOT EXISTS (SELECT 1 FROM org_freight ofr

2373: 'VALUE',
2374: p_ship_via_lookup_code_tbl(i),
2375: PO_VAL_CONSTANTS.c_ship_via_lookup_code
2376: FROM dual
2377: WHERE NOT EXISTS (SELECT 1 FROM org_freight ofr
2378: WHERE p_ship_via_lookup_code_tbl(i) = ofr.freight_code
2379: AND SYSDATE < NVL(ofr.disable_date, SYSDATE + 1)
2380: --Bug 12409257 start
2381: --AND p_org_id_tbl(i)=ofr.organization_id);