APPS.PA_DEDUCTIONS dependencies on PO_INQ_SV

Line 794: SELECT PO_INQ_SV.get_po_total (type_lookup_code,

790: AND org_id = p_org_id
791: AND nvl(status, 'REJECTED') <> 'REJECTED');
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';

Line 961: SELECT PO_INQ_SV.get_po_total (type_lookup_code,

957: WHERE expenditure_item_id = c_exp_item_id
958: AND deduction_req_tran_id <> p_dctn_txn_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;