APPS.EGO_PAGES_BULKLOAD_PVT dependencies on FND_APPLICATION

Line 23: FROM fnd_application

19:
20: /*Sets the EGO Application ID*/
21: SELECT application_id
22: INTO G_EGO_APPLICATION_ID
23: FROM fnd_application
24: WHERE application_short_name = 'EGO';
25:
26: /*Sets the EGO_ITEM OBJECT_ID*/
27: SELECT object_id

Line 392: FROM fnd_application

388: UPDATE ego_page_entries_interface epi
389: SET old_attr_group_id = (SELECT attr_group_id
390: FROM ego_fnd_dsc_flx_ctx_ext
391: WHERE application_id = (SELECT application_id
392: FROM fnd_application
393: WHERE application_short_name = 'EGO')
394: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
395: AND descriptive_flex_context_code = epi.old_attr_group_name),
396: last_updated_by = G_USER_ID,

Line 414: FROM fnd_application

410: UPDATE ego_page_entries_interface epi
411: SET new_attr_group_id = (SELECT attr_group_id
412: FROM ego_fnd_dsc_flx_ctx_ext
413: WHERE application_id = (SELECT application_id
414: FROM fnd_application
415: WHERE application_short_name = 'EGO')
416: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
417: AND descriptive_flex_context_code = epi.new_attr_group_name),
418: last_updated_by = G_USER_ID,

Line 1177: FROM fnd_application

1173: BEGIN
1174: SELECT attr_group_id INTO p_ent_tbl(i).old_attr_group_id
1175: FROM ego_fnd_dsc_flx_ctx_ext
1176: WHERE application_id = (SELECT application_id
1177: FROM fnd_application
1178: WHERE application_short_name = 'EGO')
1179: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
1180: AND descriptive_flex_context_code = p_ent_tbl(i).old_attr_group_name;
1181: EXCEPTION

Line 1214: FROM fnd_application

1210: BEGIN
1211: SELECT attr_group_id INTO p_ent_tbl(i).new_attr_group_id
1212: FROM ego_fnd_dsc_flx_ctx_ext
1213: WHERE application_id = (SELECT application_id
1214: FROM fnd_application
1215: WHERE application_short_name = 'EGO')
1216: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
1217: AND descriptive_flex_context_code = p_ent_tbl(i).new_attr_group_name;
1218: EXCEPTION