DBA Data[Home] [Help]

APPS.JE_ZZ_AUDIT_AP_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 1203: FROM fnd_id_flex_segments_vl fif

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

Line 2335: FROM fnd_id_flex_segments_vl fif

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

Line 2405: FROM fnd_id_flex_segments_vl fif

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