679: AND EXISTS
680: (
681: SELECT
682: NULL
683: FROM po_lines_all pol ,
684: po_line_types_b polt
685: WHERE pol.po_header_id = poh.po_header_id
686: AND NVL(pol.cancel_flag, 'N') <> 'Y'
687: AND pol.line_type_id = polt.line_type_id
7953: ,hr_api_transaction_values gtv, per_grades_tl grade
7954: ,hr_api_transaction_values vtv, po_vendors vendor
7955: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7956: ,hr_api_transaction_values htv, po_headers_all po_heads
7957: ,hr_api_transaction_values ltv, po_lines_all po_lines
7958: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7959: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7960:
7961: where
8052: AND EXISTS
8053: (
8054: SELECT
8055: NULL
8056: FROM po_lines_all pol ,
8057: po_line_types_b polt
8058: WHERE pol.po_header_id = poh.po_header_id
8059: AND NVL(pol.cancel_flag, 'N') <> 'Y'
8060: AND pol.line_type_id = polt.line_type_id