The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_select_report_or_group varchar2,
p_is_exception_group varchar2,
p_exception_group_name varchar2,
p_exception_group_name_dummy varchar2,
p_is_exception_report varchar2,
p_exception_report_name varchar2,
p_exception_report_name_dummy varchar2,
p_over_ride_variance_type varchar2,
p_over_ride_varianc_type_dumy varchar2,
p_over_ride_variance_value varchar2,
p_over_ride_varinc_value_dumy varchar2,
p_payment_method_override varchar2,
p_nacha_payment_type varchar2,
p_nacha_payment_method varchar2,
p_deposit_date_override varchar2,
p_file_id_modifier varchar2,
p_file_id_modifier_check varchar2,
p_thrid_party_check varchar2,
p_check_writer_payment_type varchar2,
p_check_style varchar2,
p_check_writer_payment_method varchar2,
p_check_writer_sort_sequence varchar2,
p_start_check_number varchar2,
p_end_check_number varchar2,
p_overriding_cheque_date varchar2,
p_payment_method_3rd_party varchar2,
p_sort_sequence_3rd_party varchar2,
p_start_check_num_3rd_party varchar2,
p_end_check_num_3rd_party varchar2,
p_da_report_category varchar2,
p_da_sort_sequence varchar2,
p_da_assignment_set varchar2,
p_assignment_set_dummy varchar2,
p_selection_criterion varchar2,
p_is_element_set varchar2,
p_ele_reg_element_set varchar2,
p_is_element_classification varchar2,
p_element_classification varchar2,
p_is_element_name varchar2,
p_element varchar2,
p_ele_reg_employee varchar2,
p_costing_process varchar2,
p_dummy_cost_run varchar2,
p_cost_summary_accruals varchar2,
p_cost_summary_file_out varchar2,
p_cost_detail_selection varchar2,
p_cost_detail_is_ele_set varchar2,
p_cost_detail_ele_set varchar2,
p_cost_detail_is_class varchar2,
p_cost_detail_class varchar2,
p_cost_detail_is_element varchar2,
p_cost_detail_element varchar2,
p_cost_detail_asg_set varchar2,
p_cost_detail_accruals varchar2,
p_start_date varchar2,
p_end_date varchar2,
p_ppa_finder varchar2,
p_ppa_finder_pqp varchar2
) is
l_valid_status varchar2(5);
select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
select RUNNABLE_FLAG
into lv_runnable_process
from wf_activities
where item_type = p_wf_item_type
and type = 'PROCESS'
and name = l_workflowprocess
and end_date is null;
p_select_report_or_group ,
p_is_exception_group ,
p_exception_group_name ,
p_exception_group_name_dummy ,
p_is_exception_report ,
p_exception_report_name ,
p_exception_report_name_dummy ,
p_over_ride_variance_type ,
p_over_ride_varianc_type_dumy ,
p_over_ride_variance_value ,
p_over_ride_varinc_value_dumy ,
p_payment_method_override ,
p_nacha_payment_type ,
p_nacha_payment_method ,
p_deposit_date_override ,
p_file_id_modifier ,
p_file_id_modifier_check ,
p_thrid_party_check ,
p_check_writer_payment_type ,
p_check_style ,
p_check_writer_payment_method ,
p_check_writer_sort_sequence ,
p_start_check_number ,
p_end_check_number ,
p_overriding_cheque_date ,
p_payment_method_3rd_party ,
p_sort_sequence_3rd_party ,
p_start_check_num_3rd_party ,
p_end_check_num_3rd_party ,
p_da_report_category ,
p_da_sort_sequence ,
p_da_assignment_set ,
p_assignment_set_dummy ,
p_selection_criterion ,
p_is_element_set ,
p_ele_reg_element_set ,
p_is_element_classification ,
p_element_classification ,
p_is_element_name ,
p_element ,
p_ele_reg_employee ,
p_costing_process ,
p_dummy_cost_run ,
p_cost_summary_accruals ,
p_cost_summary_file_out ,
p_cost_detail_selection ,
p_cost_detail_is_ele_set ,
p_cost_detail_ele_set ,
p_cost_detail_is_class ,
p_cost_detail_class ,
p_cost_detail_is_element ,
p_cost_detail_element ,
p_cost_detail_asg_set ,
p_cost_detail_accruals ,
p_start_date ,
p_end_date ,
p_ppa_finder ,
p_ppa_finder_pqp ,
l_ProcessDesc,
l_RequestorUsername,
l_ProcessOwner,
l_workflowprocess,
l_item_type,
l_item_key
);
p_select_report_or_group varchar2,
p_is_exception_group varchar2,
p_exception_group_name varchar2,
p_exception_group_name_dummy varchar2,
p_is_exception_report varchar2,
p_exception_report_name varchar2,
p_exception_report_name_dummy varchar2,
p_over_ride_variance_type varchar2,
p_over_ride_varianc_type_dumy varchar2,
p_over_ride_variance_value varchar2,
p_over_ride_varinc_value_dumy varchar2,
p_payment_method_override varchar2,
p_nacha_payment_type varchar2,
p_nacha_payment_method varchar2,
p_deposit_date_override varchar2,
p_file_id_modifier varchar2,
p_file_id_modifier_check varchar2,
p_thrid_party_check varchar2,
p_check_writer_payment_type varchar2,
p_check_style varchar2,
p_check_writer_payment_method varchar2,
p_check_writer_sort_sequence varchar2,
p_start_check_number varchar2,
p_end_check_number varchar2,
p_overriding_cheque_date varchar2,
p_payment_method_3rd_party varchar2,
p_sort_sequence_3rd_party varchar2,
p_start_check_num_3rd_party varchar2,
p_end_check_num_3rd_party varchar2,
p_da_report_category varchar2,
p_da_sort_sequence varchar2,
p_da_assignment_set varchar2,
p_assignment_set_dummy varchar2,
p_selection_criterion varchar2,
p_is_element_set varchar2,
p_ele_reg_element_set varchar2,
p_is_element_classification varchar2,
p_element_classification varchar2,
p_is_element_name varchar2,
p_element varchar2,
p_ele_reg_employee varchar2,
p_costing_process varchar2,
p_dummy_cost_run varchar2,
p_cost_summary_accruals varchar2,
p_cost_summary_file_out varchar2,
p_cost_detail_selection varchar2,
p_cost_detail_is_ele_set varchar2,
p_cost_detail_ele_set varchar2,
p_cost_detail_is_class varchar2,
p_cost_detail_class varchar2,
p_cost_detail_is_element varchar2,
p_cost_detail_element varchar2,
p_cost_detail_asg_set varchar2,
p_cost_detail_accruals varchar2,
p_start_date varchar2,
p_end_date varchar2,
p_ppa_finder varchar2,
p_ppa_finder_pqp varchar2,
ProcessDesc varchar2,
RequestorUsername varchar2,
ProcessOwner in varchar2,
Workflowprocess in varchar2,
item_type in varchar2,
item_key in varchar2
) is
ItemType varchar2(30);
select meaning
from hr_lookups
where lookup_code = p_cost_summary_accruals
and lookup_type = 'PAY_PAYRPCBR';
select meaning
from fnd_common_lookups
where lookup_code = p_cost_summary_file_out
and lookup_type = 'REPORT_OUTPUT_TYPE'
and application_id = 801
and enabled_flag = 'Y';
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_cost_detail_ele_set)
and element_set_type = 'C';
select classification_name
from pay_element_classifications
where classification_id = to_number(p_cost_detail_class);
select tl.element_name
from pay_element_types_f el, pay_element_types_f_tl tl
where el.element_type_id = to_number(p_cost_detail_element)
and el.element_type_id = tl.element_type_id
and tl.language = userenv('LANG')
and fnd_date.canonical_to_date(p_date_earned)
between el.effective_start_date and el.effective_end_date;
select assignment_set_name
from hr_assignment_sets
where assignment_set_id = to_number(p_cost_detail_asg_set);
select meaning
from hr_lookups
where lookup_code = p_cost_detail_accruals
and lookup_type = 'PAY_PAYRPCBR';
select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
select currency_code into lv_currency_code
from per_business_groups
where business_group_id = p_business_group_id;
SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
FROM PAY_PAYMENT_TYPES PPT,
PER_BUSINESS_GROUPS BG
WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
OR PPT.TERRITORY_CODE IS NULL)
AND BG.BUSINESS_GROUP_ID= p_business_group_id
AND PPT.PAYMENT_TYPE_NAME = 'NACHA'
);
SELECT to_char(PPT.PAYMENT_TYPE_ID)
into ln_check_payment_type_id
FROM PAY_PAYMENT_TYPES PPT,
PER_BUSINESS_GROUPS BG
WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
OR PPT.TERRITORY_CODE IS NULL)
AND BG.BUSINESS_GROUP_ID= p_business_group_id
AND PPT.PAYMENT_TYPE_NAME = 'Check'
);
select report_name into lv_da_report
from pay_report_format_mappings_f
where report_type = 'DAR'
and report_category = p_da_report_category;
select payroll_name into lv_payroll_name
from pay_all_payrolls_f
where payroll_id = p_payroll_id
and fnd_date.canonical_to_date(p_date_earned)
between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
select consolidation_set_name into lv_consolidation_set_name
from pay_consolidation_sets
where consolidation_set_id = p_consolidation_set_id;
select name into lv_gre_name
from hr_tax_units_v
where tax_unit_id = to_number(p_gre);
select PERIOD_NAME into lv_period_name
from per_time_periods
where time_period_id = p_period;
select event_group_name
into lv_event_group_name
from pay_event_groups
where event_group_id = substr(p_event_group,12,length(p_event_group));
select ORG_PAYMENT_METHOD_NAME
into lv_nacha_pymt_name
from pay_org_payment_methods_f
where business_group_id = p_business_group_id
and org_payment_method_id = p_nacha_payment_method
and fnd_date.canonical_to_date(p_date_earned)
between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
select ORG_PAYMENT_METHOD_NAME
into lv_check_pymt_name
from pay_org_payment_methods_f
where business_group_id = p_business_group_id
and org_payment_method_id = p_check_writer_payment_method
and fnd_date.canonical_to_date(p_date_earned)
between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
select ORG_PAYMENT_METHOD_NAME
into lv_pre_ovr_pymt_name
from pay_org_payment_methods_f
where business_group_id = p_business_group_id
and org_payment_method_id = p_payment_method_override
and fnd_date.canonical_to_date(p_date_earned)
between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
select nvl(parameter_value,'WAIT')
into lv_Payroll_WF_Notify_Action
from pay_action_parameters
where parameter_name = 'PAYROLL_WF_NOTIFY_ACTION';
select meaning
into lv_check_sort_seq_meaning
from fnd_common_lookups
where lookup_type = 'CHEQUE_PROCEDURE'
and lookup_code = p_check_writer_sort_sequence;
select per.exception_report_name ,
hr_general.decode_lookup('PQP_VARIANCE_TYPES',per.variance_type) ovt,
to_char(per.VARIANCE_VALUE)
into lv_exc_rep_name,lv_orv_type,lv_orv_value
from pqp_exception_reports per
where legislation_code = 'US'
and per.exception_report_id = p_exception_report_name;
select perg.exception_report_name ,
hr_general.decode_lookup('PQP_VARIANCE_TYPES',perg.variance_type) ovt,
to_char(VARIANCE_VALUE)
into lv_exc_grp_name,lv_grp_orv_type,lv_grp_orv_value
from pqp_exception_report_groups perg
where legislation_code = 'US'
and perg.EXCEPTION_GROUP_ID = p_exception_group_name;
select element_name
into lv_element_name
from pay_element_types_f
where element_type_id = p_element;
select
batch_name
into lv_batch_name
from pay_batch_headers
where batch_id = p_batch_id;
select orig_system,orig_system_id,name,display_name
into l_orig_system,l_orig_system_id,l_role_name,l_role_display_name
from wf_roles
where name = lv_contact_user_name ;
select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
into l_profile_per_sec_id
from dual;
select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
into l_profile_per_sec_id
from dual;
select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
into l_profile_per_bg
from dual;
select fnd_profile_server.value('SECURITY_GROUP_ID')
into l_profile_sec_grp_id
from dual;
select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
into l_profile_sec_grp_id
from dual;
select fnd_profile_server.value('USERNAME')
into l_profile_user_name
from dual;
If (p_selection_criterion is not null ) and
((p_ele_reg_element_set is not null) or
(p_element_classification is not null) or
(p_element is not null))
then
lv_is_ele_reg := 'Y';
varname(i) := 'SELECT_REPORT_OR_GROUP';
varval(i) := p_select_report_or_group;
varname(i) := 'SELECTION_CRITERION';
varval(i) := p_selection_criterion;
varval(i) := p_cost_detail_selection;
select prl.prl_information1
from pay_payrolls_f prl
where prl.payroll_id = ln_payroll_id
and prl.prl_information_category = 'US'
and fnd_date.canonical_to_date(l_effective_date) between
prl.effective_start_date and prl.effective_end_date;
select org.org_information1
from hr_organization_information org
where org.org_information_context || '' = 'Contact Information'
and org.organization_id = ln_gre_id;