APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 405: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||

401: -- new code will have p_data_level and must return only one record
402: --
403: BEGIN
404: l_dynamic_sql := 'SELECT DISTINCT(assoc.data_level_id) ' ||
405: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||
406: ' WHERE ag.attr_group_id = '||p_attr_group_id ||
407: ' AND dl.attr_group_type = ag.descriptive_flexfield_name '||
408: ' AND dl.application_id = ag.application_id ';
409: IF p_data_level_name IS NOT NULL THEN

Line 6213: FROM EGO_FND_DSC_FLX_CTX_EXT

6209: IF p_pre_event_flag IS NULL THEN
6210: /*
6211: SELECT BUSINESS_EVENT_FLAG
6212: INTO l_is_event_enabled_flag
6213: FROM EGO_FND_DSC_FLX_CTX_EXT
6214: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID;*/
6215: SELECT COUNT(*)
6216: INTO l_dummy
6217: FROM EGO_ATTR_GROUP_DL

Line 6231: FROM EGO_FND_DSC_FLX_CTX_EXT

6227: ELSE --Added for 4105841
6228: /*
6229: SELECT PRE_BUSINESS_EVENT_FLAG
6230: INTO l_is_event_enabled_flag
6231: FROM EGO_FND_DSC_FLX_CTX_EXT
6232: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID;*/
6233: SELECT COUNT(*)
6234: INTO l_dummy
6235: FROM EGO_ATTR_GROUP_DL

Line 17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)

17664: CURSOR relevant_ag_w_data_level(
17665: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
17666: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17667: ,p_obj_name fnd_objects.obj_name%TYPE
17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17669: IS
17670: SELECT assoc.attr_group_id
17671: FROM ego_obj_ag_assocs_b assoc,
17672: fnd_objects object,

Line 17673: ego_fnd_dsc_flx_ctx_ext ag

17669: IS
17670: SELECT assoc.attr_group_id
17671: FROM ego_obj_ag_assocs_b assoc,
17672: fnd_objects object,
17673: ego_fnd_dsc_flx_ctx_ext ag
17674: WHERE assoc.classification_code = p_class_code
17675: AND assoc.object_id = object.object_id
17676: AND object.obj_name = p_obj_name
17677: AND ag.descriptive_flexfield_name = p_ag_type

Line 17684: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)

17680:
17681: CURSOR relevant_ag_wo_data_level(
17682: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17683: ,p_obj_name fnd_objects.obj_name%TYPE
17684: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17685: IS
17686: SELECT assoc.attr_group_id
17687: FROM ego_obj_ag_assocs_b assoc,
17688: fnd_objects object,

Line 17689: ego_fnd_dsc_flx_ctx_ext ag

17685: IS
17686: SELECT assoc.attr_group_id
17687: FROM ego_obj_ag_assocs_b assoc,
17688: fnd_objects object,
17689: ego_fnd_dsc_flx_ctx_ext ag
17690: WHERE assoc.classification_code = p_class_code
17691: AND assoc.object_id = object.object_id
17692: AND object.obj_name = p_obj_name
17693: AND ag.descriptive_flexfield_name = p_ag_type

Line 18469: ' EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL,'||

18465: l_dynamic_sql := ' SELECT /*+ LEADING( assoc_tbl) */ ATTR_GROUP_TBL.ATTR_GROUP_ID, ATTR_TBL.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP_NAME,'||
18466: ' ATTR_TBL.END_USER_COLUMN_NAME ATTR_NAME, REQUIRED_FLAG, DEFAULT_VALUE , ASSOC_TBL.DATA_LEVEL,'||
18467: ' ATTR_EXT_TBL.DATA_TYPE'||
18468: ' FROM FND_DESCR_FLEX_COLUMN_USAGES ATTR_TBL,'||
18469: ' EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL,'||
18470: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL,'||
18471: ' EGO_FND_DF_COL_USGS_EXT ATTR_EXT_TBL'||
18472: ' WHERE ATTR_TBL.APPLICATION_ID = ATTR_GROUP_TBL.APPLICATION_ID ';
18473: