[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select cpg.pay_group_id, cpg.name, cs.period_set_name, cpg.period_type, cps.period_name, cps.period_year, cps.quarter_num, cps.start_date, cps.end_date
from cn_pay_groups cpg, cn_period_statuses cps, cn_period_sets cs
where (cpg.period_set_id = cps.period_set_id) and
(cpg.period_type_id = cps.period_type_id) and
(cpg.start_date <= cps.start_date) and
( nvl(cpg.end_date, cps.end_date) >= cps.end_date) and
(cpg.period_set_id = cs.period_set_id) and
(cpg.pay_group_id = p_pay_group_id) order by cps.period_id;
select cpg.pay_group_id a,
cpg.name b,
cs.period_set_name c,
cpg.period_type d,
csr.name e,
csr.employee_number f,
cspg.start_date g,
nvl(cspg.end_date, cpg.end_date) h
from cn_pay_groups cpg,
cn_salesreps csr,
cn_srp_pay_groups cspg,
cn_period_sets cs
where (cpg.pay_group_id = cspg.pay_group_id) and
(csr.salesrep_id = cspg.salesrep_id) and
(cpg.period_set_id = cs.period_set_id) and
(cpg.pay_group_id = p_pay_group_id);
select cpg.pay_group_id a,
cpg.name b,
cs.period_set_name c,
cpg.period_type d,
csr.name e,
csr.role_id f,
cspg.start_date g,
cspg.end_date h
from cn_pay_groups cpg,
cn_roles csr,
cn_role_pay_groups cspg,
cn_period_sets cs
where (cpg.pay_group_id = cspg.pay_group_id) and
(csr.role_id = cspg.role_id) and
(cpg.pay_group_id = p_pay_group_id);