APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 175: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

171: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
172: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
173: INTO L_BALANCING_SEGMENT
174: FROM GL_CODE_COMBINATIONS GCC,
175: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
176: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
177: AND FSAV.ATTRIBUTE_VALUE = 'Y'
178: AND FSAV.APPLICATION_ID = 101
179: AND FSAV.ID_FLEX_CODE = 'GL#'--Fix bug#7334017 add

Line 595: ,fnd_segment_attribute_values fsav

591: al.code_combination_id
592: FROM xla_ae_lines al
593: ,xla_ae_headers ah
594: ,xla_ae_line_acs ala
595: ,fnd_segment_attribute_values fsav
596: ,gl_code_combinations gcc
597: ,ja_cn_ledger_le_bsv_gt glsv
598: WHERE ah.gl_transfer_status_code = ''Y''
599: AND al.ae_header_id = ah.ae_header_id

Line 647: ,fnd_segment_attribute_values fsav

643: ,al.application_id
644: FROM xla_ae_lines al
645: ,xla_ae_headers ah
646: ,xla_ae_line_acs ala
647: ,fnd_segment_attribute_values fsav
648: ,fnd_segment_attribute_values fsav1
649: ,gl_code_combinations gcc
650: ,gl_code_combinations gcc1
651: ,ja_cn_ledger_le_bsv_gt glsv

Line 648: ,fnd_segment_attribute_values fsav1

644: FROM xla_ae_lines al
645: ,xla_ae_headers ah
646: ,xla_ae_line_acs ala
647: ,fnd_segment_attribute_values fsav
648: ,fnd_segment_attribute_values fsav1
649: ,gl_code_combinations gcc
650: ,gl_code_combinations gcc1
651: ,ja_cn_ledger_le_bsv_gt glsv
652: ,ja_cn_cash_accounts_all jca