[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nvl(count(fue.user_entity_id),0) prev_emp_count
from ff_Archive_items fai
,ff_user_entities fue
where fue.user_entity_id = fai.user_entity_id
and fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
and fai.context1 = p_assignment_action_id
group by fai.context1;
select fai1.value nst_amount_expected,
fai2.value nst_receivable_sep_pay,
fai3.value nst_amount_expected_prev,
fai4.value,
fai5.value,
fai6.value,
fai7.value
from ff_Archive_items fai1,
ff_user_entities fue1,
ff_Archive_items fai2,
ff_user_entities fue2,
ff_Archive_items fai3,
ff_user_entities fue3,
ff_Archive_items fai4,
ff_user_entities fue4,
ff_Archive_items fai5,
ff_user_entities fue5,
ff_Archive_items fai6,
ff_user_entities fue6,
ff_Archive_items fai7,
ff_user_entities fue7
where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_ASG_RUN'
and fue1.user_entity_id = fai1.user_entity_id
and fai1.context1 = p_assact
and fue2.user_entity_name = 'A_RECEIVABLE_SEPARATION_PAY_ASG_RUN'
and fue2.user_entity_id = fai2.user_entity_id
and fai2.context1 = fai1.context1
-- Bug 9247404
and fue3.user_entity_name = 'A_PREV_SEP_PENS_DTLS_AMT_EXP_STAT_SEP_ENTRY_VALUE'
and fue3.user_entity_id = fai3.user_entity_id
and fai3.context1 = fai1.context1
and fue4.user_entity_name = 'A_DEFERRED_AMOUNT_STAT_ASG_RUN'
and fue4.user_entity_id = fai4.user_entity_id
and fai4.context1 = fai1.context1
and fue5.user_entity_name = 'A_RECEIVED_AMOUNT_STAT_ASG_RUN'
and fue5.user_entity_id = fai5.user_entity_id
and fai5.context1 = fai1.context1
and fue6.user_entity_name = 'A_PREV_SEP_PENS_DTLS_DEFERRED_AMOUNT_STAT_ENTRY_VALUE'
and fue6.user_entity_id = fai6.user_entity_id
and fai6.context1 = fai1.context1
and fue7.user_entity_name = 'A_PREV_SEP_PENS_DTLS_RECEIVED_AMOUNT_STAT_ENTRY_VALUE'
and fue7.user_entity_id = fai7.user_entity_id
and fai7.context1 = fai1.context1;
select fai1.value amount_expected,
fai2.value receivable_sep_pay,
fai3.value amount_expected_prev,
fai4.value,
fai5.value,
fai6.value,
fai7.value
from ff_Archive_items fai1,
ff_user_entities fue1,
ff_Archive_items fai2,
ff_user_entities fue2,
ff_Archive_items fai3,
ff_user_entities fue3,
ff_Archive_items fai4,
ff_user_entities fue4,
ff_Archive_items fai5,
ff_user_entities fue5,
ff_Archive_items fai6,
ff_user_entities fue6,
ff_Archive_items fai7,
ff_user_entities fue7
where fue1.user_entity_name = 'A_AMOUNT_EXPECTED_NONSTAT_ASG_RUN'
and fue1.user_entity_id = fai1.user_entity_id
and fai1.context1 = p_assact
and fue2.user_entity_name = 'A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN'
and fue2.user_entity_id = fai2.user_entity_id
and fai2.context1 = fai1.context1
-- Bug 9247404
and fue3.user_entity_name = 'A_PREV_SEP_PENS_DTLS_AMT_EXP_NONSTAT_SEP_ENTRY_VALUE'
and fue3.user_entity_id = fai3.user_entity_id
and fai3.context1 = fai1.context1
and fue4.user_entity_name = 'A_DEFERRED_AMOUNT_NONSTAT_ASG_RUN'
and fue4.user_entity_id = fai4.user_entity_id
and fai4.context1 = fai1.context1
and fue5.user_entity_name = 'A_RECEIVED_AMOUNT_NONSTAT_ASG_RUN'
and fue5.user_entity_id = fai5.user_entity_id
and fai5.context1 = fai1.context1
and fue6.user_entity_name = 'A_PREV_SEP_PENS_DTLS_DEFERRED_AMOUNT_NONSTAT_ENTRY_VALUE'
and fue6.user_entity_id = fai6.user_entity_id
and fai6.context1 = fai1.context1
and fue7.user_entity_name = 'A_PREV_SEP_PENS_DTLS_RECEIVED_AMOUNT_NONSTAT_ENTRY_VALUE'
and fue7.user_entity_id = fai7.user_entity_id
and fai7.context1 = fai1.context1;
select fai1.value,
fai2.value,
fai3.value,
fai4.value
from ff_Archive_items fai1,
ff_user_entities fue1,
ff_Archive_items fai2,
ff_user_entities fue2,
ff_Archive_items fai3,
ff_user_entities fue3,
ff_Archive_items fai4,
ff_user_entities fue4
where fue1.user_entity_name = 'A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN'
and fue1.user_entity_id = fai1.user_entity_id
and fai1.context1 = p_assact
-- Bug 9247404
and fue2.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
and fue2.user_entity_id = fai2.user_entity_id
and fai2.context1 = fai1.context1
and fue3.user_entity_name = 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN'
and fue3.user_entity_id = fai3.user_entity_id
and fai3.context1 = fai1.context1
and fue4.user_entity_name = 'A_RECEIVABLE_SEPARATION_PAY_ASG_RUN'
and fue4.user_entity_id = fai4.user_entity_id
and fai4.context1 = fai1.context1;
select fai1.value,
fai2.value,
fai3.value,
fai4.value
from ff_Archive_items fai1,
ff_user_entities fue1,
ff_Archive_items fai2,
ff_user_entities fue2,
ff_Archive_items fai3,
ff_user_entities fue3,
ff_Archive_items fai4,
ff_user_entities fue4
where fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
and fue1.user_entity_id = fai1.user_entity_id
and fai1.context1 = p_assact
and fue2.user_entity_name = 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN'
and fue2.user_entity_id = fai2.user_entity_id
and fai2.context1 = fai1.context1
and fue3.user_entity_name = 'A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN'
and fue3.user_entity_id = fai3.user_entity_id
and fai3.context1 = fai1.context1
and fue4.user_entity_name = 'A_RECEIVABLE_SEPARATION_PAY_ASG_RUN'
and fue4.user_entity_id = fai4.user_entity_id
and fai4.context1 = fai1.context1;