DBA Data[Home] [Help]

APPS.JE_ZZ_AUDIT_AP_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 1308: FROM fnd_id_flex_segments_vl fif

1304: FOR c_balancing_segment IN company_info
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

Line 2438: FROM fnd_id_flex_segments_vl fif

2434:
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

Line 2508: FROM fnd_id_flex_segments_vl fif

2504:
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