DBA Data[Home] [Help]

APPS.OE_AUDIT_HISTORY_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 2019: FROM FND_DESCR_FLEX_COL_USAGE_VL

2015: p_column_label VARCHAR2(500);
2016: BEGIN
2017: SELECT NVL(FORM_LEFT_PROMPT,FORM_ABOVE_PROMPT)
2018: INTO p_column_label
2019: FROM FND_DESCR_FLEX_COL_USAGE_VL
2020: WHERE APPLICATION_ID=660
2021: AND APPLICATION_COLUMN_NAME=p_appl_column_name
2022: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
2023: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('Global Data Elements',p_context_value);

Line 2029: FROM FND_DESCR_FLEX_COL_USAGE_VL

2025: EXCEPTION WHEN NO_DATA_FOUND THEN
2026: BEGIN
2027: SELECT NVL(FORM_LEFT_PROMPT,FORM_ABOVE_PROMPT)
2028: INTO p_column_label
2029: FROM FND_DESCR_FLEX_COL_USAGE_VL
2030: WHERE APPLICATION_ID=660
2031: AND APPLICATION_COLUMN_NAME=p_appl_column_name
2032: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
2033: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_old_context_value;

Line 2057: FROM FND_DESCR_FLEX_COL_USAGE_VL

2053: BEGIN
2054:
2055: SELECT DESCRIPTIVE_FLEX_CONTEXT_CODE
2056: INTO v_context
2057: FROM FND_DESCR_FLEX_COL_USAGE_VL
2058: WHERE APPLICATION_ID=660
2059: AND APPLICATION_COLUMN_NAME=p_appl_column_name
2060: AND DESCRIPTIVE_FLEXFIELD_NAME=p_flexfield_name
2061: AND DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('Global Data Elements',p_context_value);