APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_OBJECTS

Line 47: FROM cn_objects

43: WHERE alias = l_alias
44: AND (org_id = p_org_id)
45: AND internal_table_id IN(
46: SELECT object_id
47: FROM cn_objects
48: WHERE (NAME = 'CN_COMMISSION_LINES' OR NAME = 'CN_COMMISSION_HEADERS')
49: AND object_type = 'TBL'
50: AND (org_id = p_org_id));
51: BEGIN

Line 1250: from cn_objects

1246: /* PROCEDURE get_type_tree
1247: (x_types OUT NOCOPY expr_type_tbl_type) IS
1248: cursor osc_elements is
1249: select user_name, name, alias, object_id
1250: from cn_objects
1251: where calc_eligible_flag = 'Y'
1252: and object_type in ('TBL', 'VIEW')
1253: and user_name is not null
1254: and object_id < 0

Line 1261: from cn_objects

1257: order by user_name;
1258:
1259: cursor table_columns(p_table_id number) is
1260: select user_name, name
1261: from cn_objects
1262: where table_id = p_table_id
1263: and calc_formula_flag = 'Y'
1264: and object_type = 'COL'
1265: order by user_name;

Line 1287: from cn_objects

1283: order by name;
1284:
1285: cursor ext_elements is
1286: select user_name, name, alias, object_id
1287: from cn_objects
1288: where calc_eligible_flag = 'Y'
1289: and object_type in ('TBL', 'VIEW')
1290: and user_name is not null
1291: and object_id > 0

Line 1888: FROM cn_objects

1884: CURSOR get_tbl(l_segment IN VARCHAR2) IS
1885: SELECT user_name
1886: , object_id
1887: , NAME
1888: FROM cn_objects
1889: WHERE calc_eligible_flag = 'Y'
1890: AND object_type IN('TBL', 'VIEW')
1891: AND user_name IS NOT NULL
1892: AND alias = l_segment;

Line 1896: FROM cn_objects

1892: AND alias = l_segment;
1893:
1894: CURSOR get_col(l_segment IN VARCHAR2, l_table_id IN NUMBER) IS
1895: SELECT user_name
1896: FROM cn_objects
1897: WHERE table_id = l_table_id
1898: AND calc_formula_flag = 'Y'
1899: AND object_type = 'COL'
1900: AND user_name IS NOT NULL