APPS.PO_UDA_TEMPLATES_UTIL dependencies on EGO_DATA_LEVEL_B

Line 322: FROM EGO_DATA_LEVEL_B

318: d_progress := 340;
319:
320: SELECT DATA_LEVEL_NAME
321: INTO l_data_level_name
322: FROM EGO_DATA_LEVEL_B
323: WHERE ATTR_GROUP_TYPE IN
324: (
325: SELECT ENTITY_CODE
326: FROM PO_UDA_AG_TEMPLATES

Line 1489: FROM EGO_DATA_LEVEL_B

1485: END IF;
1486:
1487: SELECT DATA_LEVEL_ID
1488: INTO l_data_level_id
1489: FROM EGO_DATA_LEVEL_B
1490: WHERE ATTR_GROUP_TYPE = p_attr_group_type
1491: AND DATA_LEVEL_NAME = p_data_level_name;
1492:
1493: d_progress := 20;

Line 1518: FROM EGO_DATA_LEVEL_B

1514:
1515:
1516: SELECT DATA_LEVEL_ID
1517: INTO l_data_level_id
1518: FROM EGO_DATA_LEVEL_B
1519: WHERE ATTR_GROUP_TYPE = p_attr_group_type
1520: AND DATA_LEVEL_NAME = p_data_level_name || '_ARCHIVE';
1521:
1522: d_progress := 40;

Line 3017: ego_data_level_b levels,

3013: BEGIN
3014: SELECT 1, dummy_def.DESCRIPTIVE_FLEX_CONTEXT_CODE
3015: INTO l_data_level_present, x_internal_name
3016: FROM ego_fnd_dsc_flx_ctx_ext dummy_def,
3017: ego_data_level_b levels,
3018: ego_attr_group_dl dummy_level
3019: WHERE levels.DATA_LEVEL_ID = dummy_level.DATA_LEVEL_ID
3020: AND dummy_def.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_UDA_DUMMY_EXT_ATTRS'
3021: AND dummy_def.ATTR_GROUP_ID = dummy_level.ATTR_GROUP_ID

Line 5744: FROM ego_data_level_b

5740:
5741: --Get the dummy data level id
5742: SELECT data_level_name
5743: INTO l_dummy_data_level
5744: FROM ego_data_level_b
5745: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5746: AND data_level_name= (SELECT attr_group_type FROM ego_data_level_b WHERE data_level_name= p_data_level);
5747:
5748: --Get the dummy classfication code,Revision -to display in the attribute group page

Line 5746: AND data_level_name= (SELECT attr_group_type FROM ego_data_level_b WHERE data_level_name= p_data_level);

5742: SELECT data_level_name
5743: INTO l_dummy_data_level
5744: FROM ego_data_level_b
5745: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5746: AND data_level_name= (SELECT attr_group_type FROM ego_data_level_b WHERE data_level_name= p_data_level);
5747:
5748: --Get the dummy classfication code,Revision -to display in the attribute group page
5749: SELECT ptl.display_name || ', Rev ' || pt.revision
5750: INTO l_dummy_classfication_code

Line 5871: FROM ego_data_level_b

5867:
5868: --Get the dummy data level id
5869: SELECT data_level_name
5870: INTO l_dummy_data_level
5871: FROM ego_data_level_b
5872: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5873: AND data_level_name= (SELECT attr_group_type FROM ego_data_level_b WHERE data_level_name= l_real_data_level);
5874:
5875: --Get the dummy association id.

Line 5873: AND data_level_name= (SELECT attr_group_type FROM ego_data_level_b WHERE data_level_name= l_real_data_level);

5869: SELECT data_level_name
5870: INTO l_dummy_data_level
5871: FROM ego_data_level_b
5872: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5873: AND data_level_name= (SELECT attr_group_type FROM ego_data_level_b WHERE data_level_name= l_real_data_level);
5874:
5875: --Get the dummy association id.
5876: SELECT association_id
5877: INTO l_dummy_associaton_id