APPS.OKC_MRV_UTIL dependencies on FND_APPLICATION

Line 57: -- Get application ID from fnd_application

53: p_pk1_column_name VARCHAR2 (200) := 'CAT_ID';
54: p_pk2_column_name VARCHAR2 (200) := 'VARIABLE_CODE';
55: l_sql VARCHAR2 (1000);
56: BEGIN
57: -- Get application ID from fnd_application
58: SELECT application_id
59: INTO p_application_id
60: FROM fnd_application
61: WHERE application_short_name = 'OKC';

Line 60: FROM fnd_application

56: BEGIN
57: -- Get application ID from fnd_application
58: SELECT application_id
59: INTO p_application_id
60: FROM fnd_application
61: WHERE application_short_name = 'OKC';
62:
63: IF (p_data_type = 'C' OR p_data_type = 'A')
64: THEN

Line 527: FROM ego_attr_groups_v attr, fnd_application fa

523: l_agdispname VARCHAR2 (240);
524: BEGIN
525: SELECT attr.attr_group_disp_name
526: INTO l_agdispname
527: FROM ego_attr_groups_v attr, fnd_application fa
528: WHERE attr.attr_group_type = 'OKC_K_ART_VAR_EXT_ATTRS'
529: AND fa.application_short_name = 'OKC'
530: AND attr.application_id = fa.application_id
531: AND attr.attr_group_id = TO_NUMBER (attrgroupid);