APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 159: l_manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE;

155:
156: l_cancel_flag po_lines_all.cancel_flag%TYPE;
157: l_po_release_id po_line_locations_all.po_release_id%TYPE;
158:
159: l_manual_po_num_type PO_SYSTEM_PARAMETERS.manual_po_num_type%TYPE;
160:
161: -- Bug 5684304: Removed the prefix 'Subcontracting Order '
162: -- for the cursor column to be placed in the l_report_title_num variable
163: CURSOR l_cur_get_blanket_po (

Line 378: FROM po_system_parameters_all psp

374: commit;
375:
376: SELECT psp.manual_po_num_type manual_po_num_type
377: INTO l_manual_po_num_type
378: FROM po_system_parameters_all psp
379: where org_id = p_ou_id;
380:
381: /* EXCEPTION
382: WHEN no_data_found THEN