APPS.FII_GL_CCID_C dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 198: FROM FND_SEGMENT_ATTRIBUTE_VALUES fsav1,

194: fsav3.application_column_name
195: INTO p_company_seg,
196: p_cc_seg,
197: p_natural_seg
198: FROM FND_SEGMENT_ATTRIBUTE_VALUES fsav1,
199: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,
200: FND_SEGMENT_ATTRIBUTE_VALUES fsav3
201: WHERE fsav1.application_id = 101
202: AND fsav1.id_flex_code = 'GL#'

Line 199: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,

195: INTO p_company_seg,
196: p_cc_seg,
197: p_natural_seg
198: FROM FND_SEGMENT_ATTRIBUTE_VALUES fsav1,
199: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,
200: FND_SEGMENT_ATTRIBUTE_VALUES fsav3
201: WHERE fsav1.application_id = 101
202: AND fsav1.id_flex_code = 'GL#'
203: AND fsav1.id_flex_num = p_coa_id

Line 200: FND_SEGMENT_ATTRIBUTE_VALUES fsav3

196: p_cc_seg,
197: p_natural_seg
198: FROM FND_SEGMENT_ATTRIBUTE_VALUES fsav1,
199: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,
200: FND_SEGMENT_ATTRIBUTE_VALUES fsav3
201: WHERE fsav1.application_id = 101
202: AND fsav1.id_flex_code = 'GL#'
203: AND fsav1.id_flex_num = p_coa_id
204: AND fsav1.segment_attribute_type = 'GL_BALANCING'

Line 309: FROM FND_SEGMENT_ATTRIBUTE_VALUES

305:
306: delete from FII_CCID_SLG_GT where COA_ID = l_coa_id;
307:
308: SELECT application_column_name INTO l_company_seg
309: FROM FND_SEGMENT_ATTRIBUTE_VALUES
310: WHERE application_id = 101
311: AND id_flex_code = 'GL#'
312: AND id_flex_num = l_coa_id
313: AND segment_attribute_type = 'GL_BALANCING'

Line 1023: FND_SEGMENT_ATTRIBUTE_VALUES fsav1,

1019: fii_source_ledger_groups slg
1020: WHERE slg.usage_code = 'DBI'
1021: AND slg.source_ledger_group_id = sts.source_ledger_group_id
1022: ) coa_list,
1023: FND_SEGMENT_ATTRIBUTE_VALUES fsav1,
1024: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,
1025: FND_SEGMENT_ATTRIBUTE_VALUES fsav3
1026: WHERE fsav1.application_id = 101
1027: AND fsav1.id_flex_code = 'GL#'

Line 1024: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,

1020: WHERE slg.usage_code = 'DBI'
1021: AND slg.source_ledger_group_id = sts.source_ledger_group_id
1022: ) coa_list,
1023: FND_SEGMENT_ATTRIBUTE_VALUES fsav1,
1024: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,
1025: FND_SEGMENT_ATTRIBUTE_VALUES fsav3
1026: WHERE fsav1.application_id = 101
1027: AND fsav1.id_flex_code = 'GL#'
1028: AND fsav1.id_flex_num = coa_list.chart_of_accounts_id

Line 1025: FND_SEGMENT_ATTRIBUTE_VALUES fsav3

1021: AND slg.source_ledger_group_id = sts.source_ledger_group_id
1022: ) coa_list,
1023: FND_SEGMENT_ATTRIBUTE_VALUES fsav1,
1024: FND_SEGMENT_ATTRIBUTE_VALUES fsav2,
1025: FND_SEGMENT_ATTRIBUTE_VALUES fsav3
1026: WHERE fsav1.application_id = 101
1027: AND fsav1.id_flex_code = 'GL#'
1028: AND fsav1.id_flex_num = coa_list.chart_of_accounts_id
1029: AND fsav1.segment_attribute_type = 'GL_BALANCING'