APPS.PO_DOC_STYLE_GRP dependencies on PO_DOC_STYLE_HEADERS

Line 48: FROM po_doc_style_headers pdsh,

44: INTO l_count
45: FROM dual
46: WHERE exists (
47: SELECT NULL
48: FROM po_doc_style_headers pdsh,
49: po_doc_style_lines_vl pdsl
50: WHERE pdsl.display_name = p_name
51: AND pdsh.style_id = pdsl.style_id
52: AND pdsh.status = 'ACTIVE'

Line 114: FROM po_doc_style_headers pdsh

110: INTO l_count
111: FROM dual
112: WHERE exists (
113: SELECT NULL
114: FROM po_doc_style_headers pdsh
115: WHERE pdsh.style_name = p_name
116: AND pdsh.style_id <> nvl(p_style_id, -9999));
117:
118: l_progress := '020';

Line 177: FROM po_doc_style_headers pdhs

173: INTO l_count
174: FROM dual
175: WHERE exists (
176: SELECT NULL
177: FROM po_doc_style_headers pdhs
178: WHERE style_type = 'STANDARD'
179: and style_id = p_style_id);
180:
181: l_progress := '020';

Line 228: FROM po_doc_style_headers pdhs

224: l_progress := '010';
225:
226: SELECT style_id
227: INTO l_style_id
228: FROM po_doc_style_headers pdhs
229: WHERE style_type = 'STANDARD';
230:
231: l_progress := '020';
232:

Line 345: FROM po_doc_style_headers pdsh

341: , x_price_differentials_flag
342: , x_progress_payment_flag
343: , x_contract_financing_flag
344: , x_line_type_allowed
345: FROM po_doc_style_headers pdsh
346: WHERE pdsh.style_id = p_style_id;
347:
348: l_progress := '030';
349: