[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT tier_unit_code, commission_unit_code
INTO l_tier_unit_code, l_comm_unit_code
FROM cn_rate_schedules rs
WHERE rs.rate_schedule_id = p_pe_rec.rate_table_id;
SELECT COUNT(*)
INTO l_tmp
FROM cn_rate_tiers rt
WHERE rt.rate_schedule_id = p_pe_rec.rate_table_id
;
SELECT tier_unit_code, commission_unit_code
INTO l_tier_unit_code, l_comm_unit_code
FROM cn_rate_schedules rs
WHERE rs.rate_schedule_id = p_pe_rec.disc_rate_table_id;
SELECT COUNT(*)
INTO l_tmp
FROM cn_rate_tiers rt
WHERE rt.rate_schedule_id = p_pe_rec.disc_rate_table_id
;
SELECT meaning INTO l_yes FROM fnd_lookups
WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_no FROM fnd_lookups
WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_yes FROM fnd_lookups
WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_no FROM fnd_lookups
WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_yes FROM fnd_lookups
WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_no FROM fnd_lookups
WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_yes FROM fnd_lookups
WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_no FROM fnd_lookups
WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_yes FROM fnd_lookups
WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_no FROM fnd_lookups
WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_yes FROM fnd_lookups
WHERE lookup_code = 'Y' AND lookup_type = 'YES_NO';
SELECT meaning INTO l_no FROM fnd_lookups
WHERE lookup_code = 'N' AND lookup_type = 'YES_NO';
SELECT event_factor,
trx_type
FROM cn_trx_factors
WHERE quota_rule_id = p_quota_rule_id;
SELECT q.NAME
INTO l_pe_name
FROM cn_quotas q,
cn_quota_rules qr
WHERE qr.quota_rule_id = p_quota_rule_id AND q.quota_id = qr.quota_id;
SELECT quota_id
INTO l_quota_id
FROM cn_quotas_v
WHERE NAME = p_quota_name
AND org_id = p_org_id ;
SELECT NAME
INTO l_cf_name
FROM cn_calc_formulas
WHERE calc_formula_id = p_calc_formula_id;
SELECT calc_formula_id
INTO l_cf_id
FROM cn_calc_formulas
WHERE NAME = p_calc_formula_name and org_id = p_org_id;
SELECT NAME
INTO l_c_type
FROM cn_credit_types
WHERE credit_type_id = p_credit_type_id;
SELECT NAME
INTO l_name
FROM cn_interval_types
WHERE interval_type_id = p_interval_type_id
AND org_id = p_org_id;
SELECT quota_rule_id
INTO l_quota_rule_id
FROM cn_quota_rules
WHERE quota_id = p_quota_id AND revenue_class_id = p_rev_class_id;
SELECT end_date + 1
FROM cn_quota_rule_uplifts
WHERE quota_rule_id = p_quota_rule_id
ORDER BY end_date DESC;
SELECT quota_rule_uplift_id
FROM cn_quota_rule_uplifts
WHERE quota_rule_id = p_quota_rule_id AND TRUNC (start_date) = TRUNC (p_start_date) AND TRUNC (end_date) = TRUNC (p_end_date);
SELECT quota_rule_uplift_id
FROM cn_quota_rule_uplifts
WHERE quota_rule_id = p_quota_rule_id AND TRUNC (start_date) = TRUNC (p_start_date) AND TRUNC (end_date) IS NULL;
SELECT rt_quota_asgn_id
FROM cn_rt_quota_asgns
WHERE quota_id = p_quota_id
AND rate_schedule_id = p_rate_schedule_id
AND calc_formula_id = p_calc_formula_id
AND TRUNC (start_date) = TRUNC (p_start_date)
AND TRUNC (end_date) = TRUNC (p_end_date);
SELECT rt_quota_asgn_id
FROM cn_rt_quota_asgns
WHERE quota_id = p_quota_id
AND rate_schedule_id = p_rate_schedule_id
AND calc_formula_id = p_calc_formula_id
AND TRUNC (start_date) = TRUNC (p_start_date)
AND TRUNC (end_date) IS NULL;
SELECT start_date,
end_date
INTO l_child_start_date,
l_child_end_date
FROM cn_quotas
WHERE quota_id = child_quota_id;
SELECT NAME
INTO l_calc_name
FROM cn_calc_formulas
WHERE calc_formula_id = p_plan_element.calc_formula_id;
SELECT formula_type
INTO l_formula_type
FROM cn_calc_formulas
WHERE calc_formula_id = p_plan_element.calc_formula_id;
SELECT start_date,
end_date
FROM cn_quotas
WHERE quota_id = p_quota_id;
SELECT start_date,
end_date
FROM cn_rt_quota_asgns
WHERE quota_id = p_quota_id
AND calc_formula_id = p_calc_formula_id
AND rt_quota_asgn_id <> NVL (p_rt_quota_asgn_id, 0)
AND TRUNC (start_date) < TRUNC (p_start_date)
ORDER BY start_date DESC;
SELECT start_date,
end_date
FROM cn_rt_quota_asgns
WHERE quota_id = p_quota_id
AND calc_formula_id = p_calc_formula_id
AND rt_quota_asgn_id <> NVL (p_rt_quota_asgn_id, 0)
AND TRUNC (start_date) > TRUNC (p_start_date)
ORDER BY start_date ASC;
SELECT start_date,
end_date
FROM cn_quota_rule_uplifts
WHERE quota_rule_id = p_quota_rule_id
AND quota_rule_uplift_id <> NVL (p_quota_rule_uplift_id, 0)
AND TRUNC (start_date) < TRUNC (p_start_date)
ORDER BY start_date DESC;
SELECT start_date,
end_date
FROM cn_quota_rule_uplifts
WHERE quota_rule_id = p_quota_rule_id
AND quota_rule_uplift_id <> NVL (p_quota_rule_uplift_id, 0)
AND TRUNC (start_date) > TRUNC (p_start_date)
ORDER BY start_date ASC;
SELECT quota_type_code
INTO l_quota_type
FROM cn_quotas
WHERE quota_id = p_quota_id;
SELECT Count(1)
FROM cn_rt_formula_asgns
WHERE calc_formula_id = p_calc_formula_id
and ( start_Date < p_start_date
or ( p_end_date IS NOT NULL
and end_date IS NULL )
or end_date > p_end_date ); */
SELECT MIN (start_date),
MAX (NVL (end_date, l_null_date))
INTO l_temp_start_date,
l_temp_end_date
FROM cn_rt_formula_asgns
WHERE calc_formula_id = p_calc_formula_id;
SELECT cp.start_date,
cp.end_date
FROM cn_quota_assigns cq,
cn_comp_plans cp
WHERE cq.comp_plan_id = cp.comp_plan_id AND cq.quota_id = p_quota_id;
SELECT COUNT (1)
FROM cn_quota_rule_uplifts u,
cn_quota_rules r
WHERE r.quota_id = p_quota_id
AND r.quota_rule_id = u.quota_rule_id
AND (u.start_date < p_start_date OR (p_end_date IS NOT NULL AND u.end_date IS NULL) OR u.end_date > p_end_date);
SELECT COUNT (1)
FROM cn_rt_quota_asgns u
WHERE u.quota_id = p_quota_id
AND (u.start_date < p_start_date OR (p_end_date IS NOT NULL AND u.end_date IS NULL) OR u.end_date > p_end_date);