DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 2240: from fnd_descr_flex_column_usages

2236: for x in l_global_req_segs_info1.required_segment_names.first..l_global_req_segs_info1.required_segment_names.last loop
2237: select APPLICATION_COLUMN_NAME
2238: into
2239: v_application_names(l_index)
2240: from fnd_descr_flex_column_usages
2241: where END_USER_COLUMN_NAME = l_global_req_segs_info1.required_segment_names(x)
2242: and DESCRIPTIVE_FLEXFIELD_NAME = p_flexfield_name
2243: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements' ;
2244: l_index := v_application_names.NEXT(l_index);

Line 2253: from fnd_descr_flex_column_usages

2249: for y in l_context_req_segs_info1.required_segment_names.first..l_context_req_segs_info1.required_segment_names.last loop
2250: select APPLICATION_COLUMN_NAME
2251: into
2252: v_application_names(l_index)
2253: from fnd_descr_flex_column_usages
2254: where END_USER_COLUMN_NAME = l_context_req_segs_info1.required_segment_names(y) --x_context_req_segs_info1(l_index)
2255: and DESCRIPTIVE_FLEXFIELD_NAME = p_flexfield_name
2256: and DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attribute_category ;
2257: l_index := v_application_names.NEXT(l_index);