[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT legislation_code
FROM per_business_groups
WHERE business_group_id = p_business_group_id;
select
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(convert(upper(cp_input_string),'UTF8'),
utl_raw.cast_to_varchar2(hextoraw('C380')),'A'),
utl_raw.cast_to_varchar2(hextoraw('C38A')),'E'),
utl_raw.cast_to_varchar2(hextoraw('C387')),'C'),
utl_raw.cast_to_varchar2(hextoraw('C389')),'E'),
utl_raw.cast_to_varchar2(hextoraw('C39C')),'U'),
utl_raw.cast_to_varchar2(hextoraw('C399')),'U'),
utl_raw.cast_to_varchar2(hextoraw('C39B')),'U'),
utl_raw.cast_to_varchar2(hextoraw('C394')),'O'),
utl_raw.cast_to_varchar2(hextoraw('C38F')),'I'),
utl_raw.cast_to_varchar2(hextoraw('C38E')),'I'),
utl_raw.cast_to_varchar2(hextoraw('C388')),'E'),
utl_raw.cast_to_varchar2(hextoraw('C38B')),'E'),
utl_raw.cast_to_varchar2(hextoraw('C382')),'A'),
utl_raw.cast_to_varchar2(hextoraw('C592')),'OE'),
utl_raw.cast_to_varchar2(hextoraw('C386')),'AE')
from dual;
SELECT TRANSLATE (UPPER(seg.segment_name), ' /','__')
FROM fnd_id_flex_structures_vl ctx,
fnd_id_flex_segments_vl seg
WHERE ctx.id_flex_num = seg.id_flex_num
AND ctx.id_flex_code = seg.id_flex_code
AND seg.id_flex_code = 'BANK'
AND ctx.id_flex_structure_code = p_id_flex_structure_code
AND seg.application_column_name = UPPER(p_node);
select fcu.end_user_column_name
from pay_org_payment_methods_f opm
,fnd_descr_flex_column_usages fcu
where opm.org_payment_method_id=p_org_meth_id
and fcu.descriptive_flex_context_code=opm.pmeth_information_category
and fcu.application_column_name =p_tag_name
and p_eff_date between opm.effective_start_date and effective_end_date;
select fcu.end_user_column_name
from pay_personal_payment_methods_f ppm
,fnd_descr_flex_column_usages fcu
where ppm.personal_payment_method_id=p_per_meth_id
and fcu.descriptive_flex_context_code=ppm.ppm_information_category
and fcu.application_column_name =p_tag_name
and p_eff_date between ppm.effective_start_date and effective_end_date;
SELECT pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_BRANCH', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
FROM pay_external_accounts pea
WHERE p_ext_act_id = pea.external_account_id;
SELECT segment1 ,segment2 ,segment3
,segment4 ,segment5 ,segment6 ,segment7
,segment8 ,segment9 ,segment10 ,segment11
,segment12 ,segment13 ,segment14 ,segment15
,segment16 ,segment17 ,segment18 ,segment19
,segment20 ,segment21 ,segment22 ,segment23
,segment24 ,segment25 ,segment26 ,segment27
,segment28 ,segment29 ,segment30 ,popm.currency_code,
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_BRANCH', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
FROM pay_org_payment_methods_f popm
, pay_external_accounts pea
WHERE org_payment_method_id = p_org_payment_method_id
AND popm.external_account_id = pea.external_account_id
AND p_effective_date between popm.EFFECTIVE_START_DATE
and popm.EFFECTIVE_END_DATE;
SELECT segment1 ,segment2 ,segment3
,segment4 ,segment5 ,segment6 ,segment7
,segment8 ,segment9 ,segment10 ,segment11
,segment12 ,segment13 ,segment14 ,segment15
,segment16 ,segment17 ,segment18 ,segment19
,segment20 ,segment21 ,segment22 ,segment23
,segment24 ,segment25 ,segment26 ,segment27
,segment28 ,segment29 ,segment30 ,org_payment_method_id,
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_BRANCH', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code),
pppm.payee_id,pppm.payee_type
FROM pay_personal_payment_methods_f pppm
, pay_external_accounts pea
WHERE pppm.personal_payment_method_id = p_per_pay_method
AND pppm.external_account_id = pea.external_account_id
AND p_effective_date between pppm.EFFECTIVE_START_DATE
and pppm.EFFECTIVE_END_DATE;
SELECT segment1 ,segment2 ,segment3
,segment4 ,segment5 ,segment6 ,segment7
,segment8 ,segment9 ,segment10 ,segment11
,segment12 ,segment13 ,segment14 ,segment15
,segment16 ,segment17 ,segment18 ,segment19
,segment20 ,segment21 ,segment22 ,segment23
,segment24 ,segment25 ,segment26 ,segment27
,segment28 ,segment29 ,segment30 ,org_payment_method_id,
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_BRANCH', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NAME', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'BANK_ACCOUNT_NUMBER', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'TRANSIT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'SWIFT_CODE', pea.territory_code),
pay_ce_support_pkg.bank_segment_value(pea.external_account_id,'INTL_BANK_CODE', pea.territory_code)
FROM pay_org_payment_methods_f popm
, pay_external_accounts pea
WHERE org_payment_method_id = p_org_pay_method
AND popm.external_account_id = pea.external_account_id
AND p_effective_date between popm.EFFECTIVE_START_DATE
and popm.EFFECTIVE_END_DATE;
SELECT first_name
, last_name
, order_name
, full_name
, middle_names
, title
FROM per_all_people_f
where person_id=p_person_id
and p_effective_date between effective_start_date and effective_end_date;
SELECT ppf.first_name
, ppf.last_name
, ppf.order_name
, ppf.full_name
, ppf.national_identifier
, ppf.employee_number
, pj.name
, hou.name
, paf.payroll_id
, prl.payroll_name
, ppf.middle_names
, ppf.title
, paf.assignment_number
FROM per_all_assignments_f paf
, per_all_people_f ppf
, per_periods_of_service pps
, per_jobs pj
, hr_organization_units hou
, pay_payrolls_f prl
WHERE paf.person_id = ppf.person_id
and paf.assignment_id = p_assignment_id
AND paf.job_id = pj.job_id(+)
and paf.organization_id = hou.organization_id
and prl.payroll_id=paf.payroll_id
and p_effective_date between paf.effective_start_date
and paf.effective_end_date
and p_effective_date between ppf.effective_start_date
and ppf.effective_end_date
and p_effective_date between prl.effective_start_date
and prl.effective_end_date
and pps.person_id = ppf.person_id
and pps.date_start = (select max(pps1.date_start)
from per_periods_of_service pps1
where pps1.person_id = paf.person_id
and pps1.date_start <= p_effective_date);
SELECT hou.name
from hr_organization_units hou
WHERE hou.organization_id=p_organization_id;
SELECT ppa.start_date
FROM pay_payroll_actions ppa
, pay_payrolls_f pp
WHERE ppa.payroll_action_id = p_prepru_pact_id
and pp.payroll_id = ppa.payroll_id
and ppa.effective_date between pp.effective_start_date
and pp.effective_end_date;
select nvl(paa.serial_number,'-9999'),
substr(fnd_date.date_to_canonical(ppa.effective_date),1,10),
substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10),
ppa.payroll_action_id
from pay_assignment_actions paa,pay_payroll_actions ppa
where paa.assignment_action_id = p_asg_act
and paa.payroll_action_id=ppa.payroll_action_id;
select nvl(pbt.reporting_name,pbt.balance_name),
pay_balance_pkg.get_value(pba.defined_balance_id,p_asg_act)
from pay_balance_attributes pba
, pay_bal_attribute_definitions pbad
, pay_defined_balances pdb
, pay_balance_types pbt
where pbad.attribute_name='PAYMENT_EARNINGS'
and pba.attribute_id=pbad.attribute_id
and (nvl(pba.legislation_code,'XXX')=p_leg_code
or
nvl(pba.business_group_id,-999)=p_bg_id)
and pba.defined_balance_id=pdb.defined_balance_id
and pbt.balance_type_id = pdb.balance_type_id;
select nvl(pbt.reporting_name,pbt.balance_name),
pay_balance_pkg.get_value(pba.defined_balance_id,p_asg_act)
from pay_balance_attributes pba
, pay_bal_attribute_definitions pbad
, pay_defined_balances pdb
, pay_balance_types pbt
where pbad.attribute_name='PAYMENT_DEDUCTIONS'
and pba.attribute_id=pbad.attribute_id
and (nvl(pba.legislation_code,'XXX')=p_leg_code
or
nvl(pba.business_group_id,-999)=p_bg_id)
and pba.defined_balance_id=pdb.defined_balance_id
and pbt.balance_type_id = pdb.balance_type_id;
SELECT pap.accrual_plan_name
, pap.accrual_plan_id
FROM pay_accrual_plans pap
,pay_element_types_f pet
,pay_element_links_f pel
,pay_element_entries_f pee
WHERE pet.element_type_id = pap.accrual_plan_element_type_id
AND pel.element_type_id = pet.element_type_id
AND pee.element_link_id = pel.element_link_id
AND p_assignment_id = pee.assignment_id
and p_eff_date between pet.effective_start_date and pet.effective_end_date
and p_eff_date between pel.effective_start_date and pel.effective_end_date
and p_eff_date between pee.effective_start_date and pee.effective_end_date;
select min(ptp.start_date),max(ptp.end_date), max(paa.assignment_Action_id)
from pay_action_interlocks pai
,pay_assignment_actions paa
,pay_payroll_actions ppa
,per_time_periods ptp
where p_asg_act_id=pai.locking_action_id
and pai.locked_action_id=paa.assignment_action_id
and paa.source_action_id is null
and ppa.payroll_action_id = paa.payroll_action_id
AND ppa.action_type IN ('R','Q')
AND ppa.action_status = 'C'
AND ppa.time_period_id = ptp.time_period_id;
SELECT ppm_information1 ,ppm_information2,ppm_information3,ppm_information4,ppm_information5,
ppm_information6,ppm_information7,ppm_information8,ppm_information9,ppm_information10,
ppm_information11,ppm_information12,ppm_information13,ppm_information14,ppm_information15,
ppm_information16,ppm_information17,ppm_information18,ppm_information19,ppm_information20,
ppm_information21,ppm_information22,ppm_information23,ppm_information24,ppm_information25,
ppm_information26,ppm_information27,ppm_information28,ppm_information29,ppm_information30
FROM pay_personal_payment_methods_f
WHERE personal_payment_method_id = p_ppm_id
and p_effective_date between effective_start_date and effective_end_date;
SELECT pmeth_information1 ,pmeth_information2,pmeth_information3,pmeth_information4,pmeth_information5,
pmeth_information6,pmeth_information7,pmeth_information8,pmeth_information9,pmeth_information10,
pmeth_information11,pmeth_information12,pmeth_information13,pmeth_information14,pmeth_information15,
pmeth_information16,pmeth_information17,pmeth_information18,pmeth_information19,pmeth_information20
FROM pay_org_payment_methods_f
WHERE org_payment_method_id = p_opm_id
and p_effective_date between effective_start_date and effective_end_date;
g_source_bank.delete;
select instr(l_deposit_amount,'.'), precision
into is_decimal, currency_precision
from fnd_currencies fc,
fnd_currencies_tl fctl
where fc.currency_code=g_currency_code
and fc.currency_code=fctl.currency_code
and fctl.language=userenv('lang');
select length(substr(l_deposit_amount, is_decimal+1, length(l_deposit_amount)))
into curr_no_of_decimals
from dual;
select rpad(l_deposit_amount, length(l_deposit_amount)+ 1, '0')
into l_deposit_amount
from dual;
select
instr(l_deposit_amount,'.'),
substr(l_deposit_amount,-1*precision,precision)
,nvl(fctl.description,fc.currency_code)
into is_decimal,decimal_amount,currency_description
from fnd_currencies fc,
fnd_currencies_tl fctl
where fc.currency_code=g_currency_code
and fc.currency_code=fctl.currency_code
and fctl.language=userenv('lang');
select to_char(to_Date (substr(to_char(trunc(l_deposit_amount)), 1), 'j'), 'jsp'),
instr(l_deposit_amount,'.'),
substr(l_deposit_amount,-1*precision,precision)
,nvl(fctl.description,fc.currency_code)
into l_amount_in_words,is_decimal,decimal_amount,currency_description
from fnd_currencies fc ,
fnd_currencies_tl fctl
where fc.currency_code=g_currency_code
and fc.currency_code=fctl.currency_code
and fctl.language=userenv('lang');
g_person_flex.delete;