APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on GL_CODE_COMBINATIONS

Line 159: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

155: ( P_CC_ID IN NUMBER
156: )
157: RETURN VARCHAR2
158: IS
159: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
160: BEGIN
161: SELECT
162: DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
163: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 174: FROM GL_CODE_COMBINATIONS GCC,

170: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
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

Line 596: ,gl_code_combinations gcc

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
600: --AND al.analytical_balance_flag IS NOT NULL

Line 649: ,gl_code_combinations gcc

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
653: WHERE al.accounting_date >= :l_date_from

Line 650: ,gl_code_combinations gcc1

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
653: WHERE al.accounting_date >= :l_date_from
654: AND al.accounting_date < :l_date_to + 1