The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT transaction_date
FROM gl_transaction_dates
WHERE transaction_calendar_id = v_trxn_calendar_id
AND business_day_flag = 'Y'
AND transaction_date > v_new_anchor_date
ORDER BY transaction_date ASC;
SELECT transaction_date
FROM gl_transaction_dates
WHERE transaction_calendar_id = v_trxn_calendar_id
AND business_day_flag = 'Y'
AND transaction_date < v_new_anchor_date
ORDER BY transaction_date DESC;
SELECT business_day_flag
FROM gl_transaction_dates
WHERE transaction_calendar_id = v_trxn_calendar_id
AND transaction_date = CURRENT_DATE;
SELECT transaction_calendar_id
INTO v_trxn_calendar_id
FROM gl_ledgers
WHERE ledger_id = x_ledger_id;
SELECT COUNT(*)
INTO days_offset
FROM gl_transaction_dates
WHERE transaction_calendar_id = v_trxn_calendar_id
AND business_day_flag = 'Y'
AND transaction_date >= v_last_para_date
AND transaction_date < v_last_anchor_date;
SELECT COUNT(*)
INTO days_offset
FROM gl_transaction_dates
WHERE transaction_calendar_id = v_trxn_calendar_id
AND business_day_flag = 'Y'
AND transaction_date > v_last_anchor_date
AND transaction_date <= v_last_para_date;
SELECT period_name
INTO x_new_para_period
FROM gl_date_period_map m, gl_ledgers b
WHERE m.period_set_name = b.period_set_name
AND m.period_type = b.accounted_period_type
AND b.ledger_id = x_ledger_id
AND m.accounting_date = x_new_para_date;
SELECT period_name
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = x_ledger_id
AND adjustment_period_flag = 'N'
AND effective_period_num >= c_start_period_num
ORDER BY effective_period_num ASC;
SELECT period_name
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = x_ledger_id
AND adjustment_period_flag = 'N'
AND effective_period_num <= c_start_period_num
ORDER BY effective_period_num DESC;
SELECT effective_period_num
INTO l_eff_period_num
FROM gl_period_statuses p
WHERE p.application_id = 101
AND p.ledger_id = x_ledger_id
AND p.period_name = x_period_last_run
AND p.adjustment_period_flag = 'N';
SELECT effective_period_num, period_name
INTO l_start_period_num, dummy
FROM gl_period_statuses p
WHERE p.application_id = 101
AND p.ledger_id = x_ledger_id
AND x_start_date_last_run BETWEEN p.start_date
AND p.end_date
+ 0.99998843
AND p.adjustment_period_flag = 'N';
SELECT effective_period_num, period_name
INTO c_start_period_num, c_start_period
FROM gl_period_statuses p
WHERE p.application_id = 101
AND p.ledger_id = x_ledger_id
AND x_start_date_this_run BETWEEN p.start_date
AND p.end_date
+ 0.99998843
AND p.adjustment_period_flag = 'N';
SELECT COUNT(*)
INTO period_offset
FROM gl_period_statuses p
WHERE p.application_id = 101
AND p.ledger_id = x_ledger_id
AND p.effective_period_num BETWEEN l_start_period_num
AND l_eff_period_num
AND p.adjustment_period_flag = 'N';
SELECT COUNT(*)
INTO period_offset
FROM gl_period_statuses p
WHERE p.application_id = 101
AND p.ledger_id = x_ledger_id
AND p.effective_period_num BETWEEN l_eff_period_num
AND l_start_period_num
AND p.adjustment_period_flag = 'N';
SELECT start_date
INTO v_pstart_date
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = x_ledger_id
AND period_name = v_period;
SELECT batch_id,batch_type_code
FROM gl_auto_alloc_batches
WHERE allocation_set_id = v_batch_id
AND batch_type_code IN ('A','R','E','B');
SELECT consolidation_ledger_flag
into con_ledger_flag
FROM gl_system_usages;
SELECT lgr.ledger_id
into v_adb_ledger_id
FROM gl_recurring_headers rh, gl_ledgers lgr
WHERE rh.recurring_batch_id = v_batch_id
AND lgr.ledger_id = rh.ledger_id
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'N'
AND rownum = 1;
SELECT lgr.ledger_id
into v_con_ledger_id
FROM gl_recurring_headers rh, gl_ledgers lgr
WHERE rh.recurring_batch_id = v_batch_id
AND lgr.ledger_id = rh.ledger_id
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'Y'
AND rownum =1;
SELECT lgr.ledger_id
into v_adb_ledger_id
FROM gl_alloc_formulas af,
gl_alloc_formula_lines al,
gl_ledger_set_assignments lsa,
gl_ledgers lgr
WHERE af.allocation_batch_id = v_batch_id
AND al.allocation_formula_id = af.allocation_formula_id
AND al.line_number IN (4, 5)
AND lsa.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
AND sysdate BETWEEN
nvl(trunc(lsa.start_date), sysdate - 1)
AND nvl(trunc(lsa.end_date), sysdate + 1)
AND lgr.ledger_id = nvl(lsa.ledger_id,
nvl(al.ledger_id,v_ledger_id))
AND lgr.object_type_code = 'L'
AND lgr.enable_average_balances_flag= 'Y'
AND lgr.consolidation_ledger_flag = 'N'
AND rownum = 1;
SELECT lgr.ledger_id
into v_con_ledger_id
FROM gl_alloc_formulas af,
gl_alloc_formula_lines al,
gl_ledger_set_assignments ls,
gl_ledgers lgr
WHERE af.allocation_batch_id = v_batch_id
AND al.allocation_formula_id = af.allocation_formula_id
AND al.line_number IN (4, 5)
AND ls.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
AND sysdate BETWEEN
nvl(trunc(ls.start_date), sysdate - 1)
AND nvl(trunc(ls.end_date), sysdate + 1)
AND lgr.ledger_id = nvl(ls.ledger_id,
nvl(al.ledger_id,v_ledger_id))
AND lgr.object_type_code = 'L'
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'Y'
AND rownum = 1;
SELECT lgr.ledger_id
into v_adb_ledger_id
FROM gl_alloc_formulas af,
gl_alloc_formula_lines al,
gl_ledger_set_assignments lsa,
gl_ledgers lgr
WHERE af.allocation_batch_id = current_bid
AND al.allocation_formula_id = af.allocation_formula_id
AND al.line_number IN (4, 5)
AND lsa.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
AND sysdate BETWEEN
nvl(trunc(lsa.start_date), sysdate - 1)
AND nvl(trunc(lsa.end_date), sysdate + 1)
AND lgr.ledger_id = nvl(lsa.ledger_id,
nvl(al.ledger_id,v_ledger_id))
AND lgr.object_type_code = 'L'
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'N'
AND rownum = 1;
SELECT lgr.ledger_id
into v_con_ledger_id
FROM gl_alloc_formulas af,
gl_alloc_formula_lines al,
gl_ledger_set_assignments ls,
gl_ledgers lgr
WHERE af.allocation_batch_id = current_bid
AND al.allocation_formula_id = af.allocation_formula_id
AND al.line_number IN (4, 5)
AND ls.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
AND sysdate BETWEEN
nvl(trunc(ls.start_date), sysdate - 1)
AND nvl(trunc(ls.end_date), sysdate + 1)
AND lgr.ledger_id = nvl(ls.ledger_id,
nvl(al.ledger_id,v_ledger_id))
AND lgr.object_type_code = 'L'
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'Y'
AND rownum = 1;
SELECT lgr.ledger_id
into v_adb_ledger_id
FROM gl_recurring_headers rh, gl_ledgers lgr
WHERE rh.recurring_batch_id = current_bid
AND lgr.ledger_id = rh.ledger_id
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'N'
AND rownum = 1;
SELECT lgr.ledger_id
into v_con_ledger_id
FROM gl_recurring_headers rh, gl_ledgers lgr
WHERE rh.recurring_batch_id = current_bid
AND lgr.ledger_id = rh.ledger_id
AND lgr.enable_average_balances_flag = 'Y'
AND lgr.consolidation_ledger_flag = 'Y'
AND rownum =1;
SELECT period_name
INTO c_start_period
FROM gl_period_statuses p
WHERE p.application_id = 101
AND p.ledger_id = x_ledger_id
AND c_date BETWEEN p.start_date
AND p.end_date + 0.99998843
AND p.adjustment_period_flag = 'N';
SELECT batch_id,batch_type_code
FROM gl_auto_alloc_batches
WHERE allocation_set_id = x_batch_id;
SELECT ledger_id
FROM gl_recurring_headers
WHERE recurring_batch_id = random_bid;
SELECT lgr.ledger_id
FROM gl_alloc_formulas af,
gl_alloc_formula_lines afl,
gl_ledger_set_assignments lsa,
gl_ledgers lgr
WHERE af.allocation_batch_id = random_bid
AND afl.allocation_formula_id = af.allocation_formula_id
AND afl.line_number IN (4, 5)
AND lsa.ledger_set_id (+) = nvl(afl.ledger_id, x_ledger_id)
AND sysdate BETWEEN
nvl(trunc(lsa.start_date), sysdate - 1)
AND nvl(trunc(lsa.end_date), sysdate + 1)
AND lgr.ledger_id = nvl(lsa.ledger_id,
nvl(afl.ledger_id, x_ledger_id))
AND lgr.object_type_code = 'L';
SELECT lgr.ledger_id
FROM gl_alloc_formulas af,
gl_alloc_formula_lines afl,
gl_ledger_set_assignments lsa,
gl_ledgers lgr
WHERE af.allocation_batch_id = random_bid
AND afl.allocation_formula_id = af.allocation_formula_id
AND afl.line_number IN (4, 5)
AND lsa.ledger_set_id (+) = afl.ledger_id
AND sysdate BETWEEN
nvl(trunc(lsa.start_date), sysdate - 1)
AND nvl(trunc(lsa.end_date), sysdate + 1)
AND lgr.ledger_id = nvl(lsa.ledger_id, afl.ledger_id)
AND lgr.object_type_code = 'L';