APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 1085: FROM fnd_descr_flex_col_usage_vl

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

Line 1094: FROM fnd_descr_flex_col_usage_vl

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

Line 1107: FROM fnd_descr_flex_col_usage_vl flex_act

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

Line 1114: fnd_descr_flex_col_usage_vl flex_ele

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