DBA Data[Home] [Help]

APPS.JE_ZZ_AUDIT_AP_PKG dependencies on FND_FLEX_VALUES_VL

Line 1204: ,fnd_flex_values_vl ffv

1200: LOOP
1201: SELECT distinct ffv.description
1202: INTO l_company_desc
1203: FROM fnd_id_flex_segments_vl fif
1204: ,fnd_flex_values_vl ffv
1205: WHERE fif.id_flex_code = 'GL#'
1206: AND fif.application_id = 101
1207: AND fif.id_flex_num = g_struct_num
1208: AND ffv.flex_value = c_balancing_segment.jg_info_v5

Line 2336: ,fnd_flex_values_vl ffv

2332: CURSOR c_balancing_desc(p_coaid NUMBER, p_company VARCHAR2)
2333: IS
2334: SELECT ffv.description
2335: FROM fnd_id_flex_segments_vl fif
2336: ,fnd_flex_values_vl ffv
2337: WHERE fif.id_flex_code = 'GL#'
2338: AND fif.application_id = 101
2339: AND fif.id_flex_num = p_coaid
2340: AND ffv.flex_value = p_company

Line 2406: ,fnd_flex_values_vl ffv

2402: CURSOR c_balancing_desc(p_coaid NUMBER, p_company VARCHAR2)
2403: IS
2404: SELECT ffv.description
2405: FROM fnd_id_flex_segments_vl fif
2406: ,fnd_flex_values_vl ffv
2407: WHERE fif.id_flex_code = 'GL#'
2408: AND fif.application_id = 101
2409: AND fif.id_flex_num = p_coaid
2410: AND ffv.flex_value = p_company