DBA Data[Home] [Help]

APPS.ARP_RECON_REP dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 603: FROM fnd_segment_attribute_values fcav,

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

Line 1143: FROM fnd_segment_attribute_values fcav,

1139:
1140: IF p_summary_account IS NOT NULL THEN
1141: SELECT fcav.application_column_name, flex_value_set_id
1142: INTO l_natural_segment_col , l_flex_value_set_id
1143: FROM fnd_segment_attribute_values fcav,
1144: fnd_id_flex_segments fifs
1145: WHERE fcav.application_id = 101
1146: AND fcav.id_flex_code = 'GL#'
1147: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

Line 2350: FROM fnd_segment_attribute_values fcav,

2346:
2347: IF p_summary_account IS NOT NULL THEN
2348: SELECT fcav.application_column_name, flex_value_set_id
2349: INTO l_natural_segment_col , l_flex_value_set_id
2350: FROM fnd_segment_attribute_values fcav,
2351: fnd_id_flex_segments fifs
2352: WHERE fcav.application_id = 101
2353: AND fcav.id_flex_code = 'GL#'
2354: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

Line 3415: FROM fnd_segment_attribute_values fcav,

3411:
3412: IF p_summary_account IS NOT NULL THEN
3413: SELECT fcav.application_column_name, flex_value_set_id
3414: INTO l_natural_segment_col , l_flex_value_set_id
3415: FROM fnd_segment_attribute_values fcav,
3416: fnd_id_flex_segments fifs
3417: WHERE fcav.application_id = 101
3418: AND fcav.id_flex_code = 'GL#'
3419: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id

Line 3839: FROM fnd_segment_attribute_values fcav,

3835:
3836: IF p_summary_account IS NOT NULL THEN
3837: SELECT fcav.application_column_name, flex_value_set_id
3838: INTO l_natural_segment_col , l_flex_value_set_id
3839: FROM fnd_segment_attribute_values fcav,
3840: fnd_id_flex_segments fifs
3841: WHERE fcav.application_id = 101
3842: AND fcav.id_flex_code = 'GL#'
3843: AND fcav.id_flex_num = arp_recon_rep.var_tname.g_chart_of_accounts_id