[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier),
l_projfunc_currency_code)),
SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_denom * icpm.compiled_multiplier),
l_denom_currency_code)),
SUM(PA_CURRENCY.round_currency_amt(direct_cost_acct * icpm.compiled_multiplier)),
SUM(PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((direct_cost_project * icpm.compiled_multiplier),
l_project_currency_code))
into indirect_cost_sum,
indirect_cost_denom_sum,
indirect_cost_acct_sum,
indirect_cost_project_sum
FROM pa_ind_compiled_sets ics,
pa_compiled_multipliers icpm
WHERE
ics.ind_rate_sch_revision_id = rate_sch_rev_id
AND ics.organization_id = org_id
AND ics.status = 'A'
AND ics.ind_compiled_set_id =
icpm.ind_compiled_set_id
AND ics.cost_base = c_base
AND icpm.cost_base = c_base;
select ind_compiled_set_id
into x_ind_compiled_set_id
from pa_ind_compiled_sets
where ind_rate_sch_revision_id = x_rate_sch_rev_id
and organization_id = x_organization_id
and cost_base = x_cost_base
and status = 'A';
select s.ind_rate_sch_name,
sr.ind_rate_sch_revision,
pl.meaning,
sr.start_date_active,
sr.end_date_active
into x_ind_rate_sch_name,
x_ind_rate_sch_revision,
x_ind_rate_sch_revision_type,
x_start_date_active,
x_end_date_active
from pa_ind_rate_schedules s,
pa_ind_rate_sch_revisions sr,
pa_lookups pl
where s.ind_rate_sch_id = sr.ind_rate_sch_id
and sr.ind_rate_sch_revision_type = pl.lookup_code
and pl.lookup_type = 'IND RATE SCHEDULE REV TYPE'
and sr.ind_rate_sch_revision_id = x_rate_sch_rev_id;