APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_OBJECTS

Line 41: FROM cn_objects

37: WHERE alias = l_alias
38: AND (org_id = p_org_id)
39: AND internal_table_id IN(
40: SELECT object_id
41: FROM cn_objects
42: WHERE (NAME = 'CN_COMMISSION_LINES' OR NAME = 'CN_COMMISSION_HEADERS')
43: AND object_type = 'TBL'
44: AND (org_id = p_org_id));
45: BEGIN

Line 1242: from cn_objects

1238: /* PROCEDURE get_type_tree
1239: (x_types OUT NOCOPY expr_type_tbl_type) IS
1240: cursor osc_elements is
1241: select user_name, name, alias, object_id
1242: from cn_objects
1243: where calc_eligible_flag = 'Y'
1244: and object_type in ('TBL', 'VIEW')
1245: and user_name is not null
1246: and object_id < 0

Line 1253: from cn_objects

1249: order by user_name;
1250:
1251: cursor table_columns(p_table_id number) is
1252: select user_name, name
1253: from cn_objects
1254: where table_id = p_table_id
1255: and calc_formula_flag = 'Y'
1256: and object_type = 'COL'
1257: order by user_name;

Line 1279: from cn_objects

1275: order by name;
1276:
1277: cursor ext_elements is
1278: select user_name, name, alias, object_id
1279: from cn_objects
1280: where calc_eligible_flag = 'Y'
1281: and object_type in ('TBL', 'VIEW')
1282: and user_name is not null
1283: and object_id > 0

Line 1869: FROM cn_objects

1865: CURSOR get_tbl(l_segment IN VARCHAR2) IS
1866: SELECT user_name
1867: , object_id
1868: , NAME
1869: FROM cn_objects
1870: WHERE calc_eligible_flag = 'Y'
1871: AND object_type IN('TBL', 'VIEW')
1872: AND user_name IS NOT NULL
1873: AND alias = l_segment;

Line 1877: FROM cn_objects

1873: AND alias = l_segment;
1874:
1875: CURSOR get_col(l_segment IN VARCHAR2, l_table_id IN NUMBER) IS
1876: SELECT user_name
1877: FROM cn_objects
1878: WHERE table_id = l_table_id
1879: AND calc_formula_flag = 'Y'
1880: AND object_type = 'COL'
1881: AND user_name IS NOT NULL