APPS.PA_DEDUCTIONS dependencies on PO_HEADERS_ALL

Line 796: '') FROM PO_HEADERS_ALL WHERE po_header_id = p_po_header_id;

792:
793: CURSOR C4(p_po_header_id NUMBER) IS
794: SELECT PO_INQ_SV.get_po_total (type_lookup_code,
795: po_header_id,
796: '') FROM PO_HEADERS_ALL WHERE po_header_id = p_po_header_id;
797:
798: is_dctn_req_unique VARCHAR2(1) := 'Y';
799: is_debit_memo_unique VARCHAR2(1) := 'Y';
800:

Line 963: '') FROM PO_HEADERS_ALL WHERE po_header_id = p_po_header_id;

959:
960: CURSOR C3(p_po_header_id NUMBER) IS
961: SELECT PO_INQ_SV.get_po_total (type_lookup_code,
962: po_header_id,
963: '') FROM PO_HEADERS_ALL WHERE po_header_id = p_po_header_id;
964:
965: l_dctn_req_id PA_DEDUCTIONS_ALL.deduction_req_id%TYPE;
966: l_exp_item_exists VARCHAR2(1) := 'N';
967: tbl_dctn_hdr C1%ROWTYPE;