APPS.OZF_THRESHOLD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 204

SELECT committed_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 210

SELECT planned_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 217

SELECT earned_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 223

SELECT earned_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 229

SELECT paid_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 236

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;

Line: 242

SELECT recal_committed
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 414

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;

Line: 421

SELECT committed_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 427

SELECT planned_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 434

SELECT earned_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 440

SELECT earned_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 446

SELECT paid_amt
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 452

SELECT recal_committed
FROM    ozf_fund_details_v
WHERE  fund_id = p_budget_id;

Line: 751

      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;

Line: 912

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;

Line: 928

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;

Line: 964

SELECT ams_act_logs_s.NEXTVAL
FROM DUAL;

Line: 968

SELECT ams_act_logs_transaction_id_s.NEXTVAL
FROM DUAL;

Line: 974

SELECT budget_id, log_message_text
FROM ams_act_logs
WHERE log_transaction_id = p_trans_id;

Line: 980

SELECT owner,parent_fund_id
FROM ozf_Funds_All_b
WHERE fund_id = p_budget_id;

Line: 986

SELECT owner
FROM ozf_Funds_All_b
WHERE fund_id = p_budget_id;

Line: 992

SELECT short_name
FROM ozf_fund_details_v
WHERE fund_id = p_budget_id;

Line: 998

SELECT meaning
FROM ozf_lookups
WHERE lookup_type = 'OZF_VALUE_LIMIT'
AND lookup_code = p_lkup_code;

Line: 1150

                      select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;

Line: 1192

      l_owner_table.delete;