APPS.MSC_ST_UTIL dependencies on MSC_COMPANIES

Line 205: ||' FROM msc_companies mc '

201: lv_sql_stmt :=
202: 'UPDATE '|| p_table_name ||' t1 '
203: ||' SET '||p_company_id ||'= -1 '
204: ||' WHERE exists( SELECT 1 '
205: ||' FROM msc_companies mc '
206: ||' WHERE mc.company_name = nvl(t1.'||p_company_name ||' ,:lv_my_company) '
207: ||' AND mc.company_id = 1 '
208: ||' AND NVL(mc.disable_date,sysdate+1) > sysdate) '
209: ||' AND t1.process_flag ='|| G_IN_PROCESS

Line 317: /* This name is seeded with company_is = 1 in msc_companies */

313: p_my_company VARCHAR2(1000);
314: BEGIN
315:
316: /* Get the name of the own Company */
317: /* This name is seeded with company_is = 1 in msc_companies */
318: BEGIN
319: IF v_my_company IS NULL THEN
320: select company_name into p_my_company
321: from msc_companies

Line 321: from msc_companies

317: /* This name is seeded with company_is = 1 in msc_companies */
318: BEGIN
319: IF v_my_company IS NULL THEN
320: select company_name into p_my_company
321: from msc_companies
322: where company_id = 1;
323: v_my_company := p_my_company;
324: ELSE
325: p_my_company := v_my_company;