APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_FLEX_VALUES_VL

Line 3796: FND_FLEX_VALUES_VL b, -- Valores do segmento

3792: ,a.parent_flex_value
3793: ,b.flex_value child_flex_value
3794: ,b.description
3795: FROM fnd_flex_value_norm_hierarchy a, -- Hierarquia compilada
3796: FND_FLEX_VALUES_VL b, -- Valores do segmento
3797: fnd_id_flex_segments c -- Segmentos da estrutura
3798: WHERE c.application_id = 101
3799: AND c.id_flex_code = ''GL#''
3800: AND c.id_flex_num = '||g_chart_of_accounts_id||

Line 3824: FROM FND_FLEX_VALUES_VL b

3820: )
3821: CONNECT BY V.parent_flex_value = PRIOR V.child_flex_value
3822: START WITH V.parent_flex_value IN
3823: ( SELECT b.flex_value
3824: FROM FND_FLEX_VALUES_VL b
3825: WHERE b.flex_value_set_id = '||g_account_value_set_id||
3826: ' AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline
3827: ||b.compiled_value_attributes
3828: ||fnd_global.newline, instrb( fnd_global.newline

Line 3919: FROM FND_FLEX_VALUES_VL

3915: INTO l_fv_last_update_date
3916: ,l_fv_id
3917: ,l_fv_summary_flag
3918: ,l_fv_description
3919: FROM FND_FLEX_VALUES_VL
3920: WHERE flex_value = fv_parent_value(i)
3921: AND flex_value_set_id = g_account_value_set_id; -- GL Account segment value set id
3922: EXCEPTION
3923: WHEN OTHERS THEN

Line 4443: ','||g_last_update_login|| ' FROM fnd_flex_values_vl fv

4439: ,fv.description
4440: ,''|''
4441: ,'||g_created_by|| ','''||g_creation_date||''''||
4442: ','||g_last_updated_by|| ','''||g_last_update_date||''''||
4443: ','||g_last_update_login|| ' FROM fnd_flex_values_vl fv
4444: WHERE fv.flex_value_set_id = '||g_cost_center_value_set_id||
4445: ' AND EXISTS (SELECT 1
4446: FROM gl_code_combinations glcc
4447: WHERE glcc.chart_of_accounts_id = '||g_chart_of_accounts_id||