[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT legal_entity_id
FROM gl_ledger_norm_seg_vals
WHERE ledger_id = pn_ledger_id;
SELECT gjh.je_header_id,
gjh.default_effective_date,
gjh.period_name,
gjh.POSTING_ACCT_SEQ_VALUE,
gjl.je_line_num
FROM gl_je_headers gjh,
gl_je_lines gjl,
gl_code_combinations_kfv gcck,
gl_ledgers glg
WHERE gjh.je_header_id = gjl.je_header_id
AND gcck.code_combination_id = gjl.code_combination_id
AND glg.ledger_id = gjh.ledger_id
AND gjh.ledger_id = pn_ledger_id
AND gjh.status = 'P'
AND gjh.period_name = pv_period_name
AND EXISTS
(SELECT jclllbg.bal_seg_value
FROM ja_cn_ledger_le_bsv_gt jclllbg
WHERE get_balancing_segment(gjl.code_combination_id) =
jclllbg.bal_seg_value
AND jclllbg.Ledger_Id = pn_ledger_id
AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
AND NOT EXISTS
(SELECT je_header_id, je_line_number
FROM ja_cn_voucher_number jcvn
WHERE gjh.je_header_id = jcvn.je_header_id
AND gjl.je_line_num = jcvn.je_line_number
AND jcvn.ledger_id = pn_ledger_id
AND jcvn.legal_entity_id = pn_legal_entity_id
AND jcvn.period_name = pv_period_name)
ORDER BY NVL(gjh.POSTING_ACCT_SEQ_VALUE, -1) ASC,
gjh.default_effective_date ASC,
gjh.posted_date ASC,
gjh.je_header_id ASC;
SELECT gjh.je_header_id,
gjh.default_effective_date,
gjh.period_name,
gjh.POSTING_ACCT_SEQ_VALUE,
gjl.je_line_num
FROM gl_je_headers gjh,
gl_je_lines gjl,
gl_code_combinations_kfv gcck,
gl_ledgers glg
WHERE gjh.je_header_id = gjl.je_header_id
AND gcck.code_combination_id = gjl.code_combination_id
AND glg.ledger_id = gjh.ledger_id
AND gjh.ledger_id = pn_ledger_id
AND gjh.status = 'P'
AND gjh.period_name = pv_period_name
AND NOT EXISTS
(SELECT je_header_id, je_line_number
FROM ja_cn_voucher_number jcvn
WHERE gjh.je_header_id = jcvn.je_header_id
AND gjl.je_line_num = jcvn.je_line_number
AND jcvn.ledger_id = pn_ledger_id
AND jcvn.legal_entity_id = pn_legal_entity_id
AND jcvn.period_name = pv_period_name)
ORDER BY NVL(gjh.POSTING_ACCT_SEQ_VALUE, -1) ASC,
gjh.default_effective_date ASC,
gjh.posted_date ASC,
gjh.je_header_id ASC;
SELECT count(*)
INTO ln_bsv_assigned_num
FROM ja_cn_ledger_le_bsv_gt
WHERE ledger_id = pn_ledger_id;
DELETE FROM ja_cn_voucher_number
WHERE ledger_id = pn_ledger_id
AND (data_source_tag <> 'M' or data_source_tag is null)
AND legal_entity_id = pn_legal_entity_id
AND period_name = pv_period_name;
SELECT NVL(MAX(jcvn.voucher_number), 0)
INTO ln_voucher_number
FROM ja_cn_voucher_number jcvn
WHERE jcvn.ledger_id = pn_ledger_id
AND jcvn.legal_entity_id = pn_legal_entity_id
AND jcvn.period_name = pv_period_name;
INSERT INTO ja_cn_voucher_number
(ledger_id,
legal_entity_id,
period_name,
je_header_id,
je_line_number,
voucher_number,
REQUEST_ID,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES
(pn_ledger_id,
pn_legal_entity_id,
pv_period_name,
v_row.je_header_id,
v_row.je_line_num,
ln_voucher_number,
fnd_global.CONC_REQUEST_ID,
fnd_global.user_id,
SYSDATE(),
fnd_global.user_id,
SYSDATE(),
fnd_global.login_id);
DELETE FROM ja_cn_voucher_number
WHERE ledger_id = pn_ledger_id
AND (data_source_tag <> 'M' or data_source_tag is null)
AND period_name = pv_period_name;
SELECT NVL(MAX(jcvn.voucher_number), 0)
INTO ln_voucher_number
FROM ja_cn_voucher_number jcvn
WHERE jcvn.ledger_id = pn_ledger_id
AND jcvn.period_name = pv_period_name;
INSERT INTO ja_cn_voucher_number
(ledger_id,
legal_entity_id,
period_name,
je_header_id,
je_line_number,
voucher_number,
REQUEST_ID,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES
(pn_ledger_id,
v_row1.legal_entity_id,
pv_period_name,
v_row.je_header_id,
v_row.je_line_num,
ln_voucher_number,
fnd_global.CONC_REQUEST_ID,
fnd_global.user_id,
SYSDATE(),
fnd_global.user_id,
SYSDATE(),
fnd_global.login_id);
SELECT period_name
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = pn_ledger_id
AND start_date >=
(select start_date
from gl_period_statuses
where application_id = 101
and ledger_id = pn_ledger_id
and period_name = pv_period_from)
AND end_date <= (select end_date
from gl_period_statuses
where application_id = 101
and ledger_id = pn_ledger_id
and period_name = pv_period_to)
AND adjustment_period_flag = 'N'
AND closing_status <> 'N'
AND closing_status <> 'F'
ORDER BY start_date;
SELECT period_name
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = P_LEDGER_ID
AND start_date >=
(select start_date
from gl_period_statuses
where application_id = 101
and ledger_id = P_LEDGER_ID
and period_name = P_PERIOD_FROM)
AND end_date <= (select end_date
from gl_period_statuses
where application_id = 101
and ledger_id = P_LEDGER_ID
and period_name = P_PERIOD_TO)
AND closing_status <> 'N'
AND closing_status <> 'F'
ORDER BY start_date;
SELECT COUNT(VOUCHER_NUMBER),
MAX(VOUCHER_NUMBER),
MIN(VOUCHER_NUMBER)
INTO JOURNAL_AMOUNT, VOUCHER_NUMBER_TO, VOUCHER_NUMBER_FROM
FROM (SELECT DISTINCT VOUCHER_NUMBER
FROM JA_CN_VOUCHER_NUMBER
WHERE PERIOD_NAME = v_row.period_name
AND (data_source_tag <> 'M' or data_source_tag is null)
AND REQUEST_ID = fnd_global.CONC_REQUEST_ID);
SELECT
DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,
'SEGMENT4',GCC.SEGMENT4, 'SEGMENT5',GCC.SEGMENT5, 'SEGMENT6',GCC.SEGMENT6,
'SEGMENT7',GCC.SEGMENT7, 'SEGMENT8',GCC.SEGMENT8, 'SEGMENT9',GCC.SEGMENT9,
'SEGMENT10',GCC.SEGMENT10, 'SEGMENT11',GCC.SEGMENT11, 'SEGMENT12',GCC.SEGMENT12,
'SEGMENT13',GCC.SEGMENT13, 'SEGMENT14',GCC.SEGMENT14, 'SEGMENT15',GCC.SEGMENT15,
'SEGMENT16',GCC.SEGMENT16, 'SEGMENT17',GCC.SEGMENT17, 'SEGMENT18',GCC.SEGMENT18,
'SEGMENT19',GCC.SEGMENT19, 'SEGMENT20',GCC.SEGMENT20, 'SEGMENT21',GCC.SEGMENT21,
'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
INTO L_BALANCING_SEGMENT
FROM GL_CODE_COMBINATIONS GCC,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
AND FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.APPLICATION_ID = 101
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND FSAV.ID_FLEX_NUM = GCC.CHART_OF_ACCOUNTS_ID
AND FSAV.ID_FLEX_CODE = 'GL#';