APPS.PO_INVOICE_HOLD_CHECK dependencies on PO_HEADERS_ALL

Line 61: l_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

57: l_api_name VARCHAR2(60) := 'PAY_WHEN_PAID';
58: l_log_head CONSTANT VARCHAR2(100) := g_log_head
59: ||l_api_name;
60: d_progress VARCHAR2(3) := '000';
61: l_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
62: d_module VARCHAR2(70) := 'po.plsql.PO_INVOICE_HOLD_CHECK.pay_when_paid';
63:
64: BEGIN
65:

Line 86: FROM po_headers_all

82: SELECT NVL(pay_when_paid, 'N'),
83: type_lookup_code
84: INTO x_pay_when_paid,
85: l_type_lookup_code
86: FROM po_headers_all
87: WHERE po_header_id = p_po_header_id;
88:
89: IF (PO_LOG.d_stmt) THEN
90: PO_LOG.stmt(d_module, d_progress, 'pay when paid query executed');

Line 163: l_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

159: l_return_status_okc VARCHAR2(1);
160: d_progress VARCHAR2(3) := '000';
161: l_pay_when_paid VARCHAR2(1);
162: l_rev_num NUMBER;
163: l_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
164: l_deliverable_hold_flag VARCHAR2(10);
165: d_module VARCHAR2(70) := 'po.plsql.PO_INVOICE_HOLD_CHECK.deliverable_overdue_check';
166: BEGIN
167:

Line 195: FROM po_headers_all

191: type_lookup_code
192: INTO l_pay_when_paid,
193: l_rev_num,
194: l_type_lookup_code
195: FROM po_headers_all
196: WHERE po_header_id = p_po_header_id; */
197:
198: /* E and C Phase 2 changes -
199: Deliverable Hold control does not depend on the pay when paid attribute.

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 350: po_headers_all ph

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
354: SELECT DECODE(Nvl(ps.deliverable_hold_flag, 'N'),'N',Nvl(ph.pay_when_paid, 'N'),ps.deliverable_hold_flag) deliverable_hold_flag