DBA Data[Home] [Help]

APPS.HRI_BPL_SETUP_DIAGNOSTIC dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 812: fnd_descr_flex_col_usage_vl col

808: AND ctxt.global_flag = 'N'
809: AND NOT EXISTS
810: (SELECT NULL
811: FROM
812: fnd_descr_flex_col_usage_vl col
813: WHERE ctxt.application_id = col.application_id
814: AND ctxt.descriptive_flexfield_name = col.descriptive_flexfield_name
815: AND ctxt.descriptive_flex_context_code = col.descriptive_flex_context_code
816: AND col.flex_value_set_id = v_valueset_id)

Line 821: ,fnd_descr_flex_col_usage_vl col2

817: AND NOT EXISTS
818: (SELECT NULL
819: FROM
820: fnd_descr_flex_contexts_vl ctxt2
821: ,fnd_descr_flex_col_usage_vl col2
822: WHERE ctxt2.application_id = ctxt.application_id
823: AND ctxt2.descriptive_flexfield_name = ctxt.descriptive_flexfield_name
824: AND ctxt2.application_id = col2.application_id
825: AND ctxt2.descriptive_flexfield_name = col2.descriptive_flexfield_name

Line 1003: fnd_descr_flex_col_usage_vl col

999: CURSOR c_reg_structures(p_attribute VARCHAR2) IS
1000: SELECT
1001: cntxt.descriptive_flex_context_name
1002: FROM
1003: fnd_descr_flex_col_usage_vl col
1004: ,fnd_descr_flex_contexts_vl cntxt
1005: WHERE col.application_id = 800
1006: AND col.descriptive_flexfield_name = 'HR_LOCATIONS'
1007: AND application_column_name = p_attribute