DBA Data[Home] [Help]

APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 148: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

144: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
145: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
146: INTO L_BALANCING_SEGMENT
147: FROM GL_CODE_COMBINATIONS GCC,
148: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
149: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
150: AND FSAV.ATTRIBUTE_VALUE = 'Y'
151: AND FSAV.APPLICATION_ID = 101
152: AND FSAV.ID_FLEX_CODE = 'GL#'--Fix bug#7334017 add

Line 456: ,fnd_segment_attribute_values fsav

452: al.code_combination_id
453: FROM xla_ae_lines al
454: ,xla_ae_headers ah
455: ,xla_ae_line_acs ala
456: ,fnd_segment_attribute_values fsav
457: ,gl_code_combinations gcc
458: ,ja_cn_ledger_le_bsv_gt glsv
459: WHERE ah.gl_transfer_status_code = ''Y''
460: AND ah.event_type_code NOT IN (''PAYMENT CANCELLED'',''RECP_REVERSE'')

Line 504: ,fnd_segment_attribute_values fsav

500: ,ala.ac1
501: FROM xla_ae_lines al
502: ,xla_ae_headers ah
503: ,xla_ae_line_acs ala
504: ,fnd_segment_attribute_values fsav
505: ,fnd_segment_attribute_values fsav1
506: ,gl_code_combinations gcc
507: ,gl_code_combinations gcc1
508: ,ja_cn_ledger_le_bsv_gt glsv

Line 505: ,fnd_segment_attribute_values fsav1

501: FROM xla_ae_lines al
502: ,xla_ae_headers ah
503: ,xla_ae_line_acs ala
504: ,fnd_segment_attribute_values fsav
505: ,fnd_segment_attribute_values fsav1
506: ,gl_code_combinations gcc
507: ,gl_code_combinations gcc1
508: ,ja_cn_ledger_le_bsv_gt glsv
509: ,ja_cn_cash_accounts_all jca