APPS.PO_VAL_HEADERS dependencies on PO_DOC_STYLE_HEADERS

Line 250: FROM po_doc_style_headers

246:
247: --Bug 12660599
248: SELECT Nvl(clm_flag,'N')
249: INTO l_is_clm_po
250: FROM po_doc_style_headers
251: WHERE style_id = p_style_id_tbl(p_style_id_tbl.COUNT);
252:
253:
254: IF l_is_clm_po LIKE 'Y' THEN

Line 1228: FROM PO_DOC_STYLE_HEADERS PDSH

1224: , p_header_id_tbl(i)
1225: , decode(nvl(p_document_format_tbl(i), '*'), '*', c_CLM_DOCUMENT_FORMAT, c_CLM_STANDARD_FORM)
1226: , null
1227: , PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
1228: FROM PO_DOC_STYLE_HEADERS PDSH
1229: WHERE PDSH.style_id = p_style_id_tbl(i)
1230: AND nvl(clm_flag, 'N') ='Y'
1231: AND NOT EXISTS (
1232: SELECT 1

Line 1585: , PO_DOC_STYLE_HEADERS PDSH

1581: , l_segment1_tbl
1582: FROM
1583: PO_SESSION_GT SES
1584: , PO_SYSTEM_PARAMETERS_ALL PARAMS
1585: , PO_DOC_STYLE_HEADERS PDSH
1586: WHERE
1587: SES.key = l_data_key
1588: AND SES.num2 = PARAMS.org_id
1589: AND PARAMS.manual_po_num_type = c_NUMERIC

Line 2798: po_doc_style_headers PDSH

2794: FROM po_headers_all POH,
2795: hr_all_organization_units_tl HOUTL,
2796: po_doc_style_lines_vl PDSL,
2797: po_document_types_all_tl PDTL,
2798: po_doc_style_headers PDSH
2799: WHERE HOUTL.organization_id = POH.org_id
2800: AND HOUTL.language = USERENV('LANG')
2801: AND PDSL.document_subtype(+) = POH.type_lookup_code
2802: AND PDSL.style_id(+) = POH.style_id

Line 3200: FROM po_doc_style_headers

3196: END IF;
3197:
3198: SELECT style_id
3199: BULK COLLECT INTO l_clm_style_id_tbl
3200: FROM po_doc_style_headers
3201: WHERE status = 'ACTIVE'
3202: AND Nvl(clm_flag,'N') = 'Y';
3203:
3204: l_data_key := PO_CORE_S.get_session_gt_nextval();