APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 150: l_manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE;

146:
147: l_cancel_flag po_lines_all.cancel_flag%TYPE;
148: l_po_release_id po_line_locations_all.po_release_id%TYPE;
149:
150: l_manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE;
151:
152: CURSOR l_cur_get_blanket_po (
153: lp_org_id NUMBER
154: , lp_po_header_id NUMBER

Line 365: FROM po_system_parameters_all psp

361: commit;
362:
363: SELECT psp.manual_po_num_type manual_po_num_type
364: INTO l_manual_po_num_type
365: FROM po_system_parameters_all psp
366: where org_id = p_ou_id;
367:
368: /* EXCEPTION
369: WHEN no_data_found THEN