DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on PO_SYSTEM_PARAMETERS

Line 108: FROM po_system_parameters psp;

104:
105:
106: SELECT psp.security_position_structure_id
107: INTO x_security_hierarchy_id
108: FROM po_system_parameters psp;
109:
110:
111:
112: EXCEPTION

Line 209: FROM po_system_parameters psp;

205:
206:
207: SELECT psp.security_position_structure_id
208: INTO x_security_hierarchy_id
209: FROM po_system_parameters psp;
210:
211:
212: EXCEPTION
213: WHEN OTHERS THEN

Line 692: from po_system_parameters;

688: BEGIN
689: /* replacing the select statement with the new OE API. */
690: select order_source_id
691: into x_order_source_id
692: from po_system_parameters;
693:
694: --Bug# 1392077
695: --Toju George 08/31/2000
696: --Modified the call to procedure to replace req_num and line_num with ids.

Line 709: po_system_parameters psp

705: /* SELECT distinct(soh.order_number)
706: INTO x_so_number
707: FROM so_lines sol,
708: so_headers soh,
709: po_system_parameters psp
710: WHERE sol.original_system_line_reference = to_char(x_line_num)
711: AND soh.original_system_reference = x_segment1
712: AND sol.header_id = soh.header_id
713: AND soh.original_system_source_code = psp.order_source_id;