DBA Data[Home] [Help]

APPS.ARP_RECON_REP dependencies on FND_ID_FLEX_SEGMENTS

Line 603: fnd_id_flex_segments fifs

599: IF p_summary_account IS NOT NULL THEN
600: SELECT fcav.application_column_name, flex_value_set_id
601: INTO l_natural_segment_col , l_flex_value_set_id
602: FROM fnd_segment_attribute_values fcav,
603: fnd_id_flex_segments fifs
604: WHERE fcav.application_id = 101
605: AND fcav.id_flex_code = 'GL#'
606: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
607: AND fcav.attribute_value = 'Y'

Line 1125: fnd_id_flex_segments fifs

1121: IF p_summary_account IS NOT NULL THEN
1122: SELECT fcav.application_column_name, flex_value_set_id
1123: INTO l_natural_segment_col , l_flex_value_set_id
1124: FROM fnd_segment_attribute_values fcav,
1125: fnd_id_flex_segments fifs
1126: WHERE fcav.application_id = 101
1127: AND fcav.id_flex_code = 'GL#'
1128: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
1129: AND fcav.attribute_value = 'Y'

Line 1707: fnd_id_flex_segments fifs

1703: IF p_summary_account IS NOT NULL THEN
1704: SELECT fcav.application_column_name, flex_value_set_id
1705: INTO l_natural_segment_col , l_flex_value_set_id
1706: FROM fnd_segment_attribute_values fcav,
1707: fnd_id_flex_segments fifs
1708: WHERE fcav.application_id = 101
1709: AND fcav.id_flex_code = 'GL#'
1710: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
1711: AND fcav.attribute_value = 'Y'

Line 2203: fnd_id_flex_segments fifs

2199: IF p_summary_account IS NOT NULL THEN
2200: SELECT fcav.application_column_name, flex_value_set_id
2201: INTO l_natural_segment_col , l_flex_value_set_id
2202: FROM fnd_segment_attribute_values fcav,
2203: fnd_id_flex_segments fifs
2204: WHERE fcav.application_id = 101
2205: AND fcav.id_flex_code = 'GL#'
2206: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
2207: AND fcav.attribute_value = 'Y'

Line 2613: fnd_id_flex_segments fifs

2609: IF p_summary_account IS NOT NULL THEN
2610: SELECT fcav.application_column_name, flex_value_set_id
2611: INTO l_natural_segment_col , l_flex_value_set_id
2612: FROM fnd_segment_attribute_values fcav,
2613: fnd_id_flex_segments fifs
2614: WHERE fcav.application_id = 101
2615: AND fcav.id_flex_code = 'GL#'
2616: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id
2617: AND fcav.attribute_value = 'Y'