APPS.CS_ROUTING_UTL dependencies on CS_SYSTEMS_ALL_VL

Line 90: -- Description : This function retrieves a customer ID from the CS_SYSTEMS_ALL_VL

86: ------------------------------------------------------------------------------
87: -- Function : Get_Customer_From_System_Name
88: -- Usage : Used by the Routing module to get the customer ID from the
89: -- system name
90: -- Description : This function retrieves a customer ID from the CS_SYSTEMS_ALL_VL
91: -- table given a system in the installed base.
92: -- Parameters :
93: -- p_system_name IN VARCHAR2(50) Required
94: --

Line 103: p_customer_id cs_systems_all_vl.customer_id%type;

99:
100: FUNCTION Get_Customer_From_System_Name
101: ( p_system_name IN VARCHAR2)
102: RETURN NUMBER IS
103: p_customer_id cs_systems_all_vl.customer_id%type;
104:
105: --
106: -- get customer ID given a system name
107: --

Line 110: FROM cs_systems_all_vl

106: -- get customer ID given a system name
107: --
108: CURSOR c_customer_id IS
109: SELECT customer_id
110: FROM cs_systems_all_vl
111: WHERE name = p_system_name;
112: BEGIN
113:
114: OPEN c_customer_id;