APPS.PO_DOCUMENT_ACTION_AUTH dependencies on PO_HEADERS_ALL

Line 197: FROM po_headers_all poh

193: -- Generate payment sequence only if it is enabled in clm opions page and doc type is PO.
194: IF p_action_ctl_rec.document_type = 'PO' THEN
195:
196: SELECT org_id INTO l_org_id
197: FROM po_headers_all poh
198: WHERE poh.po_header_id = p_action_ctl_rec.document_id ;
199: l_enable_payment_inst := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
200: p_option_column => PO_CORE_S.g_PAYMENT_INSTR_COL);
201: IF l_enable_payment_inst = 'Y' THEN

Line 299: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;

295: )
296: IS
297:
298: l_doc_state_ok BOOLEAN;
299: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
300:
301: l_ret_sts VARCHAR2(1);
302: l_err_msg VARCHAR2(200);
303: l_bool_ret_sts BOOLEAN;

Line 415: FROM po_headers_all poh

411: d_progress := 90;
412:
413: SELECT nvl(poh.encumbrance_required_flag, 'N')
414: INTO l_enc_flag
415: FROM po_headers_all poh
416: WHERE po_header_id = p_action_ctl_rec.document_id;
417:
418: END IF;
419: