APPS.MSC_CL_COPY_DP_FORECAST dependencies on MSC_APPS_INSTANCES

Line 35: FROM msc_apps_instances' || DB_LINK || '

31:
32: BEGIN
33:
34: lv_src_sql_stmt := 'SELECT m2a_dblink, instance_id
35: FROM msc_apps_instances' || DB_LINK || '
36: WHERE m2a_dblink IS NOT NULL';
37:
38: OPEN c1 FOR lv_src_sql_stmt; -- open the REF cursor
39: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL stmt in GET_SOURCE_INSTANCE_ID is : ' ||lv_src_sql_stmt);

Line 80: FROM msc_apps_instances' || DB_LINK || '

76: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'For self instance. Value of lv_found_source is :'||lv_found_source);
77: IF (v_rp_instance_id =v_src_instance_id) THEN
78:
79: lv_src_cent_stmt := 'SELECT instance_id
80: FROM msc_apps_instances' || DB_LINK || '
81: WHERE m2a_dblink IS NULL
82: AND a2m_dblink is NULL
83: AND INSTANCE_TYPE <> 3';
84:

Line 133: FROM MSC_APPS_INSTANCES

129: LAST_UPDATED_BY,
130: CREATION_DATE,
131: CREATED_BY
132: INTO v_src_dblink ,v_last_update_date ,v_last_updated_by,v_creation_date ,v_created_by
133: FROM MSC_APPS_INSTANCES
134: WHERE INSTANCE_ID=pSource_instance_id;
135:
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'SRC DB Link- v_src_dblink is: '|| v_src_dblink );
137:

Line 170: FROM MSC_APPS_INSTANCES

166: SELECT DECODE(M2A_DBLINK,
167: NULL,'',
168: '@'||M2A_DBLINK)
169: INTO v_aps_dblink
170: FROM MSC_APPS_INSTANCES
171: WHERE INSTANCE_ID=pINSTANCE_ID;
172:
173:
174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'APS DB Link- v_aps_dblink is: '|| v_aps_dblink);