DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 681: FROM fnd_id_flex_segments

677: BEGIN
678:
679: SELECT flex_value_set_id
680: INTO g_account_value_set_id
681: FROM fnd_id_flex_segments
682: WHERE id_flex_num = g_chart_of_accounts_id
683: AND id_flex_code ='GL#'
684: AND application_id = 101
685: AND application_column_name = g_account_segment;

Line 715: FROM fnd_id_flex_segments

711: BEGIN
712:
713: SELECT flex_value_set_id
714: INTO g_cost_center_value_set_id
715: FROM fnd_id_flex_segments
716: WHERE id_flex_num = g_chart_of_accounts_id
717: AND id_flex_code ='GL#'
718: AND application_id = 101
719: AND application_column_name = g_cost_center_segment;

Line 3797: fnd_id_flex_segments c -- Segmentos da estrutura

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||
3801: ' AND c.application_column_name = '''||g_account_segment||'''