APPS.PO_INVOICE_HOLD_CHECK dependencies on PO_DOC_STYLE_HEADERS

Line 213: FROM po_doc_style_headers ps, po_headers_all poh

209: INTO l_pay_when_paid,
210: l_rev_num,
211: l_type_lookup_code,
212: l_deliverable_hold_flag
213: FROM po_doc_style_headers ps, po_headers_all poh
214: WHERE poh.po_header_id = p_po_header_id
215: AND poh.style_id = ps.style_id;
216:
217:

Line 349: FROM po_doc_style_headers ps,

345:
346: SELECT deliverable_hold_flag
347: INTO x_render_deliverable_hold
348: FROM (SELECT DECODE(Nvl(ps.deliverable_hold_flag, 'N'),'N',Nvl(ph.pay_when_paid, 'N'),ps.deliverable_hold_flag) deliverable_hold_flag
349: FROM po_doc_style_headers ps,
350: po_headers_all ph
351: WHERE ph.po_header_id = p_po_header_id
352: AND ph.style_id = ps.style_id
353: UNION

Line 355: FROM po_doc_style_headers ps,

351: WHERE ph.po_header_id = p_po_header_id
352: AND ph.style_id = ps.style_id
353: UNION
354: SELECT DECODE(Nvl(ps.deliverable_hold_flag, 'N'),'N',Nvl(ph.pay_when_paid, 'N'),ps.deliverable_hold_flag) deliverable_hold_flag
355: FROM po_doc_style_headers ps,
356: po_headers_draft_all ph
357: WHERE ph.draft_id = p_po_header_id
358: AND ph.style_id = ps.style_id);
359: