DBA Data[Home] [Help]

APPS.HRI_BPL_SETUP_DIAGNOSTIC dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 804: fnd_descr_flex_contexts_vl ctxt

800: SELECT
801: ctxt.descriptive_flex_context_code
802: ,ctxt.descriptive_flex_context_name
803: FROM
804: fnd_descr_flex_contexts_vl ctxt
805: WHERE ctxt.descriptive_flexfield_name = 'PER_JOBS'
806: AND ctxt.application_id = 800
807: AND ctxt.enabled_flag = 'Y'
808: AND ctxt.global_flag = 'N'

Line 820: fnd_descr_flex_contexts_vl ctxt2

816: AND col.flex_value_set_id = v_valueset_id)
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

Line 1004: ,fnd_descr_flex_contexts_vl cntxt

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
1008: AND cntxt.descriptive_flexfield_name = col.descriptive_flexfield_name