[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT period_type
FROM pay_payrolls_f
WHERE payroll_id = cp_payroll_id;
SELECT lookup_code
INTO v_pay_basis
FROM hr_lookups lkp
WHERE lkp.application_id = 800
AND lkp.lookup_type = 'PAY_BASIS'
AND lkp.meaning = p_freq;
SELECT user_column_name
INTO v_work_sched_name
FROM pay_user_columns
WHERE user_column_id = v_ws_id
AND NVL(business_group_id, p_bg) = p_bg
AND NVL(legislation_code,'MX') = 'MX';
SELECT TPT.number_per_fiscal_year
INTO v_periods_per_fiscal_yr
FROM pay_payrolls_f PPF,
per_time_period_types TPT,
fnd_sessions fs
WHERE PPF.payroll_id = p_payroll
AND fs.session_id = USERENV('SESSIONID')
AND fs.effective_date between PPF.effective_start_date
and PPF.effective_end_date
AND TPT.period_type = PPF.period_type;
SELECT TPT.number_per_fiscal_year
INTO v_annualizing_factor
FROM pay_payrolls_f PRL,
per_time_period_types TPT,
fnd_sessions fs
WHERE TPT.period_type = PRL.period_type
and fs.session_id = USERENV('SESSIONID')
and fs.effective_date BETWEEN PRL.effective_start_date
AND PRL.effective_end_date
AND PRL.payroll_id = p_payroll
AND PRL.business_group_id + 0 = p_bg;
END; /* SELECT LOOKUP CODE */
SELECT TPT.number_per_fiscal_year
INTO v_annualizing_factor
FROM pay_payrolls_f PRL,
per_time_period_types TPT,
fnd_sessions fs
WHERE TPT.period_type = PRL.period_type
AND fs.session_id = USERENV('SESSIONID')
AND fs.effective_date BETWEEN PRL.effective_start_date
AND PRL.effective_end_date
AND PRL.payroll_id = p_payroll
AND PRL.business_group_id + 0 = p_bg;
SELECT user_column_name
INTO v_work_sched_name
FROM pay_user_columns
WHERE user_column_id = v_ws_id
AND NVL(business_group_id, p_bg) = p_bg
AND NVL(legislation_code,'MX') = 'MX';
SELECT TPT.number_per_fiscal_year
INTO v_periods_per_fiscal_yr
FROM pay_payrolls_f ppf,
per_time_period_types tpt,
fnd_sessions fs
WHERE ppf.payroll_id = p_payroll
AND fs.session_id = USERENV('SESSIONID')
AND fs.effective_date BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND tpt.period_type = ppf.period_type;
hr_utility.trace(' selecting from per_time_period_types');
SELECT PT.number_per_fiscal_year
INTO v_annualizing_factor
FROM per_time_period_types PT
WHERE UPPER(PT.period_type) = UPPER(p_freq);
SELECT put.user_table_name
INTO c_ws_tab_name
FROM hr_organization_information hoi
,pay_user_tables put
WHERE hoi.organization_id = p_bg_id
AND hoi.org_information_context = 'Work Schedule'
AND hoi.org_information1 = put.user_table_id ;
SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
INTO v_fnd_sess_row
FROM fnd_sessions
WHERE session_id = userenv('sessionid');
SELECT 'Y'
INTO l_exists
FROM pay_user_tables put,
pay_user_columns puc
WHERE puc.user_column_name = p_ws_name
AND nvl(puc.business_group_id, p_bg_id) = p_bg_id
AND nvl(puc.legislation_code,'MX') = 'MX'
AND puc.user_table_id = put.user_table_id
AND put.user_table_name = c_ws_tab_name;
SELECT puc.user_column_name
INTO v_ws_name
FROM pay_user_tables put,
pay_user_columns puc
WHERE puc.user_column_id = p_ws_name
AND nvl(puc.business_group_id, p_bg_id) = p_bg_id
AND nvl(puc.legislation_code,'MX') = 'MX'
AND puc.user_table_id = PUT.user_table_id
AND put.user_table_name = c_ws_tab_name;
SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
4,'WED',5,'THU',6,'FRI',7,'SAT')
INTO v_curr_day
FROM DUAL;
SELECT a.assignment_id,
a.soft_coding_keyflex_id,
a.location_id,
a.payroll_id,
a.business_group_id,
a.person_id
FROM per_all_assignments_f a,
per_all_assignments_f b
WHERE b.person_id = a.person_id
AND b.assignment_id = p_assignment_id
AND p_effective_date BETWEEN a.effective_start_date
AND a.effective_end_date
AND p_effective_date BETWEEN b.effective_start_date
AND b.effective_end_date;
SELECT assignment_action_id
FROM pay_assignment_actions aa,
pay_payroll_actions pa
WHERE assignment_id = cp_asg_id
AND tax_unit_id = p_tax_unit_id
AND aa.source_action_id IS NOT NULL
AND aa.payroll_action_id = pa.payroll_action_id
AND pa.effective_date BETWEEN cp_idw_start_date AND cp_idw_report_date
ORDER BY aa.action_sequence desc;
select hoi.org_information10
from hr_organization_units hou,
hr_organization_information hoi
where hou.organization_id = cp_org_id
and hoi.org_information_context ='MX_SOC_SEC_DETAILS'
and hou.organization_id = hoi.organization_id
and cp_eff_date between hou.date_from and nvl(hou.date_to,cp_eff_date) ;
select hrl.lookup_code
,hrl.meaning
from pay_element_types_f pet,
pay_input_values_f piv,
pay_element_entries_f pee,
pay_element_entry_values_f pev,
hr_lookups hrl
where pet.element_name='Integrated Daily Wage'
and piv.element_type_id = pet.element_type_id
and piv.name ='IDW Factor Table'
and pee.element_type_id = pet.element_type_id
and pee.assignment_id = cp_asg_id
and pev.element_entry_id = pee.element_entry_id
and pev.input_value_id = piv.input_value_id
and hrl.lookup_type = 'MX_IDW_FACTOR_TABLES'
and hrl.lookup_code = pev.screen_entry_value
and cp_eff_date between pet.effective_start_date and pet.effective_end_date
and cp_eff_date between piv.effective_start_date and piv.effective_end_date
and cp_eff_date between pee.effective_start_date and pee.effective_end_date
and cp_eff_date between pev.effective_start_date and pev.effective_end_date ;
SELECT 'Y'
FROM pay_user_tables
WHERE user_table_name = cp_idw_user_table_name;
SELECT meaning
FROM fnd_lookup_values flv
WHERE flv.lookup_type = 'MX_IDW_FACTOR_TABLES'
AND flv.lookup_code = cp_idw_lookup_code
AND flv.language = 'US';
SELECT
DECODE(p_mode,
'REPORT',
ADD_MONTHS(TRUNC(p_effective_date, 'Y'),
TO_CHAR(p_effective_date, 'MM') -
DECODE(MOD(TO_NUMBER(TO_CHAR(p_effective_date,'MM')),2),
1, 1,
0, 2)
) - 1,
'BIMONTH_REPORT',
p_effective_date)
INTO ld_idw_report_date
FROM DUAL;
SELECT ADD_MONTHS(ld_idw_report_date, -2) + 1
INTO ld_idw_start_date
FROM DUAL;
SELECT iv.element_type_id,
input_value_id
INTO ln_idw_ele_id,
ln_idw_inp_id
FROM pay_element_types_f et,
pay_input_values_f iv
WHERE element_name = 'Integrated Daily Wage'
AND et.legislation_code = 'MX'
AND p_effective_date BETWEEN et.effective_start_date
AND et.effective_end_date
AND et.element_type_id = iv.element_type_id
AND iv.name = 'Variable IDW'
AND p_effective_date BETWEEN iv.effective_start_date
AND iv.effective_end_date;
SELECT fnd_number.canonical_to_number(result_value)
INTO ln_variable_idw
FROM pay_run_result_values rrv,
pay_run_results rr
WHERE assignment_action_id = ln_last_idw_action
AND element_type_id = ln_idw_ele_id
AND rr.run_result_id = rrv.run_result_id
AND rrv.input_value_id = ln_idw_inp_id;
SELECT meaning
FROM hr_lookups
WHERE lookup_type = 'PQP_RATE_TYPE'
AND lookup_code = cp_lookup_code;
SELECT user_row_id
FROM pay_user_rows_f
WHERE row_low_range_or_name = cp_contract_name
AND user_table_id = cp_user_table_id
ORDER BY user_row_id;
SELECT user_table_id
INTO ln_user_table_id
FROM pay_user_tables
WHERE user_table_name = p_user_table_name
AND ( legislation_code is NULL OR
legislation_code = 'MX');
SELECT count(*)
INTO ln_count
FROM pay_user_rows_f
WHERE row_low_range_or_name = p_row_value
AND user_table_id = ln_user_table_id;
DELETE pay_user_column_instances_f
WHERE user_row_id = rw.user_row_id;
DELETE pay_user_rows_f
WHERE user_row_id = rw.user_row_id;
SELECT user_table_id
INTO ln_user_table_id
FROM pay_user_tables
WHERE user_table_name = 'PQP_CONTRACT_TYPES'
AND (legislation_code is NULL
OR legislation_code = 'MX');
SELECT NVL(max(display_sequence), 0)+1
INTO ln_dsp_seq
FROM pay_user_rows_f
WHERE user_table_id = ln_user_table_id;
SELECT user_row_id
INTO ln_user_row_id
FROM pay_user_rows_f
WHERE row_low_range_or_name = p_contract_name
AND user_table_id = ln_user_table_id
AND ROWNUM = 1;
DELETE pay_user_column_instances_f
WHERE user_row_id = ln_user_row_id;
SELECT user_column_id
INTO ln_user_column_id
FROM pay_user_columns
WHERE user_table_id = ln_user_table_id
AND user_column_name = lt_col_det_tab(i).col_name;
SELECT period_type
INTO lv_period_type
FROM pay_all_payrolls_f ppf,
fnd_sessions fs
WHERE payroll_id = p_payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND fs.session_id = USERENV('sessionid');
SELECT period_type
INTO lv_period_type
FROM pay_all_payrolls_f ppf,
fnd_sessions fs
WHERE payroll_id = p_payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND fs.session_id = USERENV('sessionid');