[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pev.screen_entry_value
from per_pay_bases ppb,
pay_element_entries_f pee,
pay_element_entry_values_f pev
where pee.assignment_id = c_assignment_id
and ppb.pay_basis_id = c_pay_basis_id
and pee.element_entry_id = pev.element_entry_id
and ppb.input_value_id = pev.input_value_id
and c_effective_date between pev.effective_start_date
and pev.effective_end_date
and c_effective_date between pee.effective_start_date
and pee.effective_end_date;
select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
from pay_balance_dimensions pbd,
pay_defined_balances pdb,
pay_balance_types pbt
where pbt.balance_name = c_balance_name
and pbd.dimension_name = c_dimension_name
and pbt.balance_type_id = pdb.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.legislation_code = 'SG';
select LOCKED_ACTION_ID
from pay_action_interlocks
where LOCKING_ACTION_ID = p_assignment_action_id
order by locked_action_id asc;
select pai.locking_action_id
from pay_action_interlocks pai,
pay_payroll_actions ppa,
pay_assignment_actions paa
where pai.locked_action_id = c_assign_act_id
and paa.assignment_action_id=pai.locking_action_id
and ppa.payroll_action_id=paa.payroll_action_id
and ppa.action_type in ('P','U','C')
order by decode(ppa.action_type,'C',0,1) desc;
select distinct assignment_id
from per_all_assignments_f
where person_id = c_person_id
and effective_start_date <= c_date_earned
and assignment_type = 'E';
select ppa.effective_date /* Bug 4267365 */
from pay_payroll_actions ppa,
pay_assignment_actions pac
where pac.payroll_action_id = ppa.payroll_action_id
and pac.assignment_action_id = c_assignment_action_id;
select max(pac.assignment_action_id)
from pay_assignment_actions pac,
per_all_assignments_f paa,
pay_payroll_actions ppa
where paa.assignment_id = c_assignment_id
and paa.assignment_type = 'E'
and paa.assignment_id = pac.assignment_id
and pac.payroll_action_id = ppa.payroll_action_id
and ppa.action_type in ('R','Q','P','U')
and ppa.effective_date between to_date('01-01'||to_char(c_date_earned,'YYYY'),'DD-MM-YYYY')
and c_date_earned; /* Bug 4267365 */
select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
from pay_balance_dimensions pbd,
pay_defined_balances pdb,
pay_balance_types pbt
where pbt.balance_name = c_balance_name
and pbd.dimension_name = c_dimension_name
and pbt.balance_type_id = pdb.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.legislation_code = 'SG';
select LOCKED_ACTION_ID
from pay_action_interlocks
where LOCKING_ACTION_ID = p_assignment_action_id
order by locked_action_id asc;
select pai.locking_action_id
from pay_action_interlocks pai,
pay_payroll_actions ppa,
pay_assignment_actions paa
where pai.locked_action_id = c_assign_act_id
and paa.assignment_action_id=pai.locking_action_id
and ppa.payroll_action_id=paa.payroll_action_id
and ppa.action_type in ('P','U','C');
select distinct assignment_id
from per_all_assignments_f
where person_id = c_person_id
and effective_start_date <= c_date_earned
and assignment_type = 'E';
select ppa.effective_date /* Bug 4267365 */
from pay_payroll_actions ppa,
pay_assignment_actions pac
where pac.payroll_action_id = ppa.payroll_action_id
and pac.assignment_action_id = c_assignment_action_id;
select max(pac.assignment_action_id)
from pay_assignment_actions pac,
per_all_assignments_f paa,
pay_payroll_actions ppa
where paa.assignment_id = c_assignment_id
and paa.assignment_type = 'E'
and paa.assignment_id = pac.assignment_id
and pac.payroll_action_id = ppa.payroll_action_id
and ppa.action_type in ('R','Q','P','U')
and ppa.effective_date between to_date('01-01'||to_char(c_date_earned,'YYYY'),'DD-MM-YYYY')
and c_date_earned; /* Bug 4267365 */
CURSOR rate is SELECT gdr.conversion_rate
FROM gl_daily_rates gdr, gl_daily_conversion_types gdct
WHERE gdr.conversion_type = gdct.conversion_type
AND gdr.from_currency = p_from_currency
AND gdr.to_currency = p_to_currency
AND gdr.conversion_date = eff_date
AND gdct.user_conversion_type = (
SELECT puci.value
FROM pay_user_column_instances_f puci,
pay_user_rows_f pur,
pay_user_columns puc,
pay_user_tables put
WHERE puci.user_row_id = pur.user_row_id
AND puci.user_column_id = puc.user_column_id
AND pur.user_table_id = put.user_table_id
AND puc.user_table_id = put.user_table_id
AND puci.business_group_id = p_business_group_id
AND pur.ROW_LOW_RANGE_OR_NAME = 'PAY'
AND put.user_table_name = 'EXCHANGE_RATE_TYPES' );
cursor tax is SELECT tax_unit_id
FROM pay_assignment_actions
WHERE assignment_action_id = p_assignment_action_id;
select pad.address_line1,
pad.address_line2,
pad.address_line3,
pad.town_or_city,
pad.postal_code,
ftt.territory_short_name
from per_addresses pad,
fnd_territories_tl ftt
where pad.person_id = c_person_id
and ftt.language = userenv('LANG')
and ftt.territory_code = pad.country
and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate);
select hrl.address_line_1,
hrl.address_line_2,
hrl.address_line_3,
hrl.town_or_city,
hrl.postal_code,
ftt.territory_short_name
from hr_locations hrl,
fnd_territories_tl ftt
where hrl.location_id = c_location_id
and ftt.language (+) = userenv('LANG')
and ftt.territory_code (+) = hrl.country;
select fcu.currency_code
from hr_organization_information hoi,
hr_organization_units hou,
fnd_currencies fcu
where hou.business_group_id = c_business_group_id
and hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'Business Group Information'
and fcu.issuing_territory_code = hoi.org_information9;
select popm.currency_code
from pay_payrolls_f ppf,
pay_org_payment_methods_f popm
where ppf.payroll_id = c_payroll_id
and popm.org_payment_method_id = ppf.default_payment_method_id
and c_effective_date between ppf.effective_start_date and ppf.effective_end_date
and c_effective_date between popm.effective_start_date and popm.effective_end_date;
select payroll_id
from per_all_assignments_f
where assignment_id = c_assignment_id
and c_effective_date between effective_start_date and effective_end_date;