DBA Data[Home] [Help]

APPS.JE_ZZ_AUDIT_AP_PKG dependencies on FND_FLEX_VALUES_VL

Line 1309: ,fnd_flex_values_vl ffv

1305: LOOP
1306: SELECT distinct ffv.description
1307: INTO l_company_desc
1308: FROM fnd_id_flex_segments_vl fif
1309: ,fnd_flex_values_vl ffv
1310: WHERE fif.id_flex_code = 'GL#'
1311: AND fif.application_id = 101
1312: AND fif.id_flex_num = g_struct_num
1313: AND ffv.flex_value = c_balancing_segment.jg_info_v5

Line 2439: ,fnd_flex_values_vl ffv

2435: CURSOR c_balancing_desc(p_coaid NUMBER, p_company VARCHAR2)
2436: IS
2437: SELECT ffv.description
2438: FROM fnd_id_flex_segments_vl fif
2439: ,fnd_flex_values_vl ffv
2440: WHERE fif.id_flex_code = 'GL#'
2441: AND fif.application_id = 101
2442: AND fif.id_flex_num = p_coaid
2443: AND ffv.flex_value = p_company

Line 2509: ,fnd_flex_values_vl ffv

2505: CURSOR c_balancing_desc(p_coaid NUMBER, p_company VARCHAR2)
2506: IS
2507: SELECT ffv.description
2508: FROM fnd_id_flex_segments_vl fif
2509: ,fnd_flex_values_vl ffv
2510: WHERE fif.id_flex_code = 'GL#'
2511: AND fif.application_id = 101
2512: AND fif.id_flex_num = p_coaid
2513: AND ffv.flex_value = p_company