DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 196: FROM fnd_descr_flex_col_usage_vl

192: ) AS
193:
194: CURSOR csr_get_tag_name IS
195: SELECT TRANSLATE (UPPER(end_user_column_name), ' /','__') tag_name
196: FROM fnd_descr_flex_col_usage_vl
197: WHERE descriptive_flexfield_name = p_flexfield_name
198: AND descriptive_flex_context_code = p_context_code
199: AND application_column_name = UPPER (p_node)
200: AND application_id = 801; /* Bug 6522667 */

Line 402: FROM fnd_descr_flex_col_usage_vl

398: ) RETURN BOOLEAN AS
399:
400: CURSOR csr_seg_enabled IS
401: SELECT 'Y'
402: FROM fnd_descr_flex_col_usage_vl
403: WHERE descriptive_flexfield_name like 'Action Information DF'
404: AND descriptive_flex_context_code = p_context_code
405: AND application_column_name like p_application_column_name
406: AND application_id = 801 /* Bug 6522667 */