[Home] [Help]
128: ( P_CC_ID IN NUMBER
129: )
130: RETURN VARCHAR2
131: IS
132: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
133: BEGIN
134: SELECT
135: DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
136: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,
143: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
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
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'')
461: AND al.ae_header_id = ah.ae_header_id
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
510: WHERE al.accounting_date >= :l_date_from
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
510: WHERE al.accounting_date >= :l_date_from
511: AND al.accounting_date < :l_date_to + 1