APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 1086: FROM fnd_descr_flex_col_usage_vl

1082:
1083: CURSOR csr_element_entry_flex_values(v_classification_name VARCHAR2)
1084: IS
1085: SELECT application_column_name, UPPER(TRANSLATE(end_user_column_name, ' ', '_') ) NAME
1086: FROM fnd_descr_flex_col_usage_vl
1087: WHERE application_id = g_application_id AND
1088: descriptive_flexfield_name = 'Element Entry Developer DF'AND
1089: descriptive_flex_context_code = v_classification_name AND
1090: (enabled_flag IS NULL OR enabled_flag ='Y');

Line 1095: FROM fnd_descr_flex_col_usage_vl

1091:
1092: CURSOR csr_action_info_flex_fields(v_element_name VARCHAR2)
1093: IS
1094: SELECT application_column_name application_column_name, UPPER(TRANSLATE(end_user_column_name, ' ', '_') ) NAME
1095: FROM fnd_descr_flex_col_usage_vl
1096: WHERE application_id = g_application_id AND
1097: descriptive_flexfield_name = 'Action Information DF' AND
1098: descriptive_flex_context_code = v_element_name AND
1099: (enabled_flag IS NULL OR enabled_flag = 'Y');

Line 1108: FROM fnd_descr_flex_col_usage_vl flex_act

1104: v_element_name VARCHAR2,
1105: v_classification_name VARCHAR2)
1106: is
1107: SELECT UPPER(TRANSLATE(flex_act.end_user_column_name, ' ', '_') ) NAME
1108: FROM fnd_descr_flex_col_usage_vl flex_act
1109: WHERE flex_act.application_id = g_application_id AND
1110: flex_act.descriptive_flexfield_name = 'Action Information DF' AND
1111: flex_act.descriptive_flex_context_code = v_element_name AND
1112: (flex_act.enabled_flag IS NULL OR flex_act.enabled_flag = 'Y') and

Line 1115: fnd_descr_flex_col_usage_vl flex_ele

1111: flex_act.descriptive_flex_context_code = v_element_name AND
1112: (flex_act.enabled_flag IS NULL OR flex_act.enabled_flag = 'Y') and
1113: not exists ( select /*+ no_unnest */ 1
1114: from
1115: fnd_descr_flex_col_usage_vl flex_ele
1116: where
1117: flex_ele.application_id = g_application_id AND
1118: flex_ele.descriptive_flexfield_name = 'Element Entry Developer DF' AND
1119: flex_ele.descriptive_flex_context_code = v_classification_name AND