The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT committed_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT planned_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT earned_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT earned_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT paid_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
select (NVL(original_budget, 0) + (NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0))) ,committed_amt
FROM ozf_funds_all_b
WHERE fund_id = p_budget_id;
SELECT recal_committed
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
select (NVL(original_budget, 0) + (NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0)))
FROM ozf_funds_all_b
WHERE fund_id = p_budget_id;
SELECT committed_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT planned_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT earned_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT earned_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT paid_amt
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT recal_committed
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT Max(notification_creation_date)
FROM AMS_ACT_LOGS
WHERE arc_act_log_used_by = 'FTHO'
AND act_log_used_by_id = x_threshold_rule_id
AND budget_id = x_budget_id
AND threshold_id = x_threshold_id;
SELECT r.threshold_rule_id,
r.threshold_id
FROM ozf_threshold_rules_all r, ozf_thresholds_all_b t
WHERE r.threshold_id = t.threshold_id
AND t.threshold_type = 'BUDGET'
AND r.enabled_flag = 'Y'
AND r.start_date <= SYSDATE
AND r.end_date >= SYSDATE;
SELECT a.fund_id budget_id,
a.fund_number budget_number,
a.parent_fund_id parent_budget_id,
a.planned_amt planned_amt,
a.committed_amt committed_amt,
a.paid_amt paid_amt,
a.available_amount available_amt,
a.budget_amount_tc budget_amount_tc,
a.start_date_active budget_start_date,
a.end_date_active budget_end_date,
a.earned_amt utilized_Amt,
c.value_limit value_limit,
c.start_period_name start_period_name,
c.end_period_name end_period_name,
c.operator_code operator_code,
c.start_date rule_start_date,
c.end_date rule_end_date,
c.period_type period_type,
c.threshold_id threshold_id,
c.threshold_rule_id threshold_rule_id,
c.percent_amount percent_amt,
c.base_line base_line,
c.frequency_period frequency_period,
c.converted_days conv_frequency_period, --Not used in current version.
c.repeat_frequency repeat_frequency
FROM ozf_funds_all_b a,
ozf_thresholds_all_b b,
ozf_threshold_rules_all c
WHERE a.threshold_id = b.threshold_id
AND a.status_code = 'ACTIVE'
AND b.enable_flag = 'Y'
AND b.threshold_id = c.threshold_id
AND c.threshold_rule_id = p_threshold_rule_id
AND c.end_date >= SYSDATE;
SELECT ams_act_logs_s.NEXTVAL
FROM DUAL;
SELECT ams_act_logs_transaction_id_s.NEXTVAL
FROM DUAL;
SELECT budget_id, log_message_text
FROM ams_act_logs
WHERE log_transaction_id = p_trans_id;
SELECT owner,parent_fund_id
FROM ozf_Funds_All_b
WHERE fund_id = p_budget_id;
SELECT owner
FROM ozf_Funds_All_b
WHERE fund_id = p_budget_id;
SELECT short_name
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;
SELECT meaning
FROM ozf_lookups
WHERE lookup_type = 'OZF_VALUE_LIMIT'
AND lookup_code = p_lkup_code;
select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;
l_owner_table.delete;