DBA Data[Home] [Help]

APPS.AZ_FLEX_COMPILER dependencies on FND_APPLICATION

Line 115: FROM fnd_application fa, fnd_id_flex_structures_vl fifs

111: l_id_flex_struct_num fnd_id_flex_structures_vl.id_flex_num%TYPE;
112:
113: CURSOR flex_num_cursor IS
114: SELECT fifs.id_flex_num
115: FROM fnd_application fa, fnd_id_flex_structures_vl fifs
116: WHERE fa.application_short_name = p_app_short_name
117: AND fa.application_id = fifs.application_id
118: AND fifs.id_flex_code = l_id_flex_code;
119:

Line 139: FROM fnd_application fa, fnd_id_flexs fif

135: BEGIN
136: l_debug_info := 'Select Key Flex: ' || p_app_short_name || ':' || p_flex_name;
137: SELECT fif.id_flex_code
138: INTO l_id_flex_code
139: FROM fnd_application fa, fnd_id_flexs fif
140: WHERE fa.application_short_name = p_app_short_name
141: AND fa.application_id = fif.application_id
142: AND fif.id_flex_name = p_flex_name;
143:

Line 154: from fnd_application fa, fnd_descriptive_flexs_vl fdf

150: l_debug_info := 'Select Descriptive Flex: ' || p_app_short_name || ':' || p_flex_name;
151:
152: select fdf.descriptive_flexfield_name
153: into l_flex_name
154: from fnd_application fa, fnd_descriptive_flexs_vl fdf
155: where fa.application_short_name = p_app_short_name
156: and fa.application_id = fdf.application_id
157: and fdf.title = p_flex_name;
158: