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 162: l_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

158: l_return_status_okc VARCHAR2(1);
159: d_progress VARCHAR2(3) := '000';
160: l_pay_when_paid VARCHAR2(1);
161: l_rev_num NUMBER;
162: l_type_lookup_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
163: d_module VARCHAR2(70) := 'po.plsql.PO_INVOICE_HOLD_CHECK.deliverable_overdue_check';
164: BEGIN
165:
166: -- Check for the API version

Line 193: FROM po_headers_all

189: type_lookup_code
190: INTO l_pay_when_paid,
191: l_rev_num,
192: l_type_lookup_code
193: FROM po_headers_all
194: WHERE po_header_id = p_po_header_id;
195:
196:
197: