[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sum( nvl(pkt.entered_dr,0)
- nvl(pkt.entered_cr,0))
FROM gl_period_statuses per, gl_bc_packet_arrival_order ao,
gl_bc_packets pkt
WHERE per.application_id = 101
AND per.ledger_id = xledger_id
AND per.period_name = xperiod_name
AND ao.ledger_id = per.ledger_id
AND ao.affect_funds_flag = 'Y'
AND pkt.packet_id = ao.packet_id
AND pkt.ledger_id = ao.ledger_id
AND pkt.period_year * 1000 + pkt.period_num
<= per.period_year * 1000 + per.period_num
AND pkt.period_year*1000000 + pkt.quarter_num*1000 + pkt.period_num
>= decode (balance_type,
'PTD', per.period_year*1000000
+ per.quarter_num*1000
+ per.period_num,
'QTD', per.period_year*1000000
+ per.quarter_num*1000,
'YTD', per.period_year*1000000,
'PJTD', 0)
AND pkt.code_combination_id = xcode_combination_id
AND pkt.actual_flag = xactual_flag
AND ( pkt.budget_version_id = xbudget_version_id
OR xactual_flag IN ('A','E'))
AND ( pkt.encumbrance_type_id = xbudget_version_id
OR xactual_flag IN ('A','B'))
AND pkt.currency_code = xcurrency_code
AND pkt.status_code = 'A';
SELECT nvl(period_net_dr,0) - nvl(period_net_cr,0) PERIOD_NET,
nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0) BEGIN_BAL,
nvl(quarter_to_date_dr,0)-nvl(quarter_to_date_cr,0) QUARTER_BAL,
nvl(project_to_date_dr,0)-nvl(project_to_date_cr,0) PROJECT_BAL
FROM gl_balances bal
WHERE bal.ledger_id = xledger_id
AND bal.period_name = xperiod_name
AND bal.code_combination_id = xcode_combination_id
AND bal.actual_flag = xactual_flag
AND ( bal.budget_version_id = xbudget_version_id
OR xactual_flag IN ('A','E'))
AND ( bal.encumbrance_type_id = xbudget_version_id
OR xactual_flag IN ('A','B'))
AND bal.currency_code = xcurrency_code;