[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select prrv.result_value
from pay_run_result_values prrv,
pay_run_results prr,
pay_element_types_f pet,
pay_input_values_f piv,
pay_assignment_actions paa,
pay_payroll_actions ppa
where prrv.run_result_id = prr.run_result_id
and paa.assignment_action_id=lp_assignment_action_id
and prr.assignment_action_id = paa.assignment_action_id
and paa.payroll_action_id= ppa.payroll_action_id
and pet.element_type_id = piv.element_type_id
and pet.element_name=lp_element_name
and piv.name =lp_input_value_name
and piv.input_value_id = prrv.input_value_id
and pet.legislation_code = 'NL'
and piv.legislation_code = 'NL'
and ppa.date_earned between pet.effective_start_date and pet.effective_end_date
and ppa.date_earned between piv.effective_start_date and piv.effective_end_date;
select max(locked_action_id) from pay_action_interlocks where locking_action_id = p_assignment_action_id;
select context_id from ff_contexts where context_name = 'SOURCE_TEXT';
'SELECT TO_CHAR('||l_sp_percentage_rate|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16 '||
',TO_CHAR('||l_prev_tax_income||',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17 '||
','''||l_Tax_Code||''' COL01 '||
',REPLACE('''||l_Tax_Table||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL02 '||
',REPLACE('''||l_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL03 '||
',REPLACE('''||l_Labour_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL07 '||
',REPLACE('''||l_Senior_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL05 '||
','''||l_Special_Indicators||''' COL06 ' ||
',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '
||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '
||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||
'FROM dual';
'select nvl(ettl.reporting_name,et.element_type_id) COL01
, nvl(ettl.reporting_name,ettl.element_name) COL02
, pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'') COL03
, decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',
'' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)
|| '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''
|| ''''''SI Type Name'''''' || '')'') COL04
, to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
, decode(count(*),1,''1'',''2'') COL17 -- destination indicator
, decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
from pay_assignment_actions aa
, pay_run_results rr
, pay_run_result_values rrv
, pay_input_values_f iv
, pay_input_values_f_tl ivtl
, pay_element_types_f et
, pay_element_types_f_tl ettl
, pay_element_set_members esm
, pay_element_sets es
where aa.assignment_action_id :action_clause
and aa.assignment_action_id = rr.assignment_action_id
and rr.status in (''P'',''PA'')
and rr.run_result_id = rrv.run_result_id
and rr.element_type_id = et.element_type_id
and :effective_date between
et.effective_start_date and et.effective_end_date
and et.element_type_id = ettl.element_type_id
and rrv.input_value_id = iv.input_value_id
and iv.name = ''Pay Value''
and :effective_date between
iv.effective_start_date and iv.effective_end_date
and iv.input_value_id = ivtl.input_value_id
and ivtl.language = userenv(''LANG'')
and ettl.language = userenv(''LANG'')
and et.element_type_id = esm.element_type_id
and esm.element_set_id = es.element_set_id
and ( es.BUSINESS_GROUP_ID IS NULL
OR es.BUSINESS_GROUP_ID = :business_group_id )
AND ( es.LEGISLATION_CODE IS NULL
OR es.LEGISLATION_CODE = '':legislation_code'' )
and es.element_set_name = '''|| p_element_set_name ||'''
group by nvl(ettl.reporting_name,ettl.element_name)
, ettl.reporting_name
,pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'')
,nvl(ettl.reporting_name,et.element_type_id)
order by nvl(ettl.reporting_name,ettl.element_name),nvl(ettl.reporting_name,et.element_type_id)';
select paa.assignment_action_id from
pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_id =
( select assignment_id
from pay_assignment_actions
where assignment_action_id = l_assignment_action_id
)
and paa.action_status = 'C'
and paa.assignment_action_id < l_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.date_earned >= trunc(l_eff_date,'Y')
order by paa.assignment_action_id desc;
select pa.payroll_id
, aa.action_sequence
, pa.effective_date
, aa.assignment_id
, pa.business_group_id
, bg.legislation_code
, lrl.rule_mode
from pay_payroll_actions pa
, pay_assignment_actions aa
, per_business_groups bg
, pay_legislation_rules lrl
where aa.assignment_action_id = p_assignment_action_id
and aa.payroll_action_id = pa.payroll_action_id
and pa.business_group_id = bg.business_group_id
and lrl.legislation_code(+) = bg.legislation_code
and lrl.rule_type(+) = 'SAVE_ASG_RUN_BAL';
select ba.defined_balance_id
, bd.dimension_name
, bd.period_type
, bt.balance_name
, bt.reporting_name
, bt.balance_type_id
, NVL(NVL(oi.org_information7,bt.reporting_name),bt.balance_name) defined_balance_name
from pay_balance_attributes ba
, pay_bal_attribute_definitions bad
, pay_defined_balances db
, pay_balance_dimensions bd
, pay_balance_types_tl bt
, hr_organization_information oi
where bad.attribute_name = p_balance_attribute
and ( bad.BUSINESS_GROUP_ID IS NULL
OR bad.BUSINESS_GROUP_ID = l_business_group_id)
AND ( bad.LEGISLATION_CODE IS NULL
OR bad.LEGISLATION_CODE = l_legislation_code)
and bad.attribute_id = ba.attribute_id
and ba.defined_balance_id = db.defined_balance_id
and db.balance_dimension_id = bd.balance_dimension_id
and db.balance_type_id = bt.balance_type_id
and bt.language = userenv('LANG')
--
and oi.org_information1 = 'BALANCE'
--
and oi.org_information4 = to_char(bt.balance_type_id)
and oi.org_information5 = to_char(db.balance_dimension_id)
--
and oi.org_information_context = 'Business Group:SOE Detail'
and oi.organization_id = l_business_group_id
order by NVL(LPAD(oi.ORG_INFORMATION8,15,0),0),NVL(NVL(oi.org_information7,bt.reporting_name),bt.balance_name);
select rb.TAX_UNIT_ID
, rb.JURISDICTION_CODE
, rb.SOURCE_ID
, rb.SOURCE_TEXT
, rb.SOURCE_NUMBER
, rb.SOURCE_TEXT2
from pay_run_balances rb
where rb.ASSIGNMENT_ID = l_assignment_id
and l_action_sequence >= rb.action_sequence
and rb.effective_date >= l_earliest_ctx_date;
select distinct
aa.tax_unit_id tax_unit_id
, rr.jurisdiction_code jurisdiction_code
, decode(l_si_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_ID'
,rr.run_result_id)
,null) source_id
, decode(l_st_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
,rr.run_result_id)
,null) source_text
, decode(l_sn_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
,rr.run_result_id)
,null) source_number
, decode(l_st2_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
,rr.run_result_id)
,null) source_text2
from pay_assignment_actions aa,
pay_payroll_actions pa,
pay_run_results rr
where aa.ASSIGNMENT_ID = l_assignment_id
and aa.assignment_action_id = rr.assignment_action_id
and l_action_sequence >= aa.action_sequence
and aa.payroll_action_id = pa.payroll_action_id
and pa.effective_date >= l_earliest_ctx_date;
select max(locked_action_id) from pay_action_interlocks where locking_action_id = p_assignment_action_id;
return ('select null COL01 from dual where 1=0');