[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_ele_selection_criterion varchar2,
p_ele_is_element_set varchar2,
p_ele_element_set varchar2,
p_ele_is_element_class varchar2,
p_ele_element_class varchar2,
p_ele_is_element_name varchar2,
p_ele_element_name varchar2,
p_ele_employee varchar2,
p_deduction_class varchar2,
p_deduction_name varchar2,
p_deduction_sort_one varchar2,
p_deduction_sort_two varchar2,
p_deduction_sort_three varchar2,
p_reg_suppress_zero varchar2,
p_reg_full_report_ver varchar2,
p_reg_reporting_dim varchar2,
p_reg_sort_one varchar2,
p_reg_sort_two varchar2,
p_reg_sort_three varchar2,
p_reg_employee_page_break varchar2,
p_reg_req_num varchar2,
p_dd_payment_type varchar2,
p_dd_payment_method varchar2,
p_dd_override_date varchar2,
p_dd_financial_inst varchar2,
p_dd_cpa_code varchar2,
p_dd_file_number varchar2,
p_cheque_payment_type varchar2,
p_cheque_payment_method varchar2,
p_cheque_sort_sequence varchar2,
p_cheque_style varchar2,
p_start_cheque_number varchar2,
p_end_cheque_number varchar2,
p_da_data_type varchar2,
p_payment_rep_payment_type varchar2,
p_payment_rep_payment_method varchar2,
p_roe_assignment_set varchar2,
p_roe_worksheet_person varchar2,
p_roe_mag_media_person varchar2,
p_roe_mag_roe_type 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
) is
l_workflowprocess varchar2(100);
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_ele_selection_criterion,
p_ele_is_element_set,
p_ele_element_set,
p_ele_is_element_class,
p_ele_element_class,
p_ele_is_element_name,
p_ele_element_name,
p_ele_employee,
p_deduction_class,
p_deduction_name,
p_deduction_sort_one,
p_deduction_sort_two,
p_deduction_sort_three,
p_reg_suppress_zero,
p_reg_full_report_ver,
p_reg_reporting_dim,
p_reg_sort_one,
p_reg_sort_two,
p_reg_sort_three,
p_reg_employee_page_break,
p_reg_req_num,
p_dd_payment_type,
p_dd_payment_method,
p_dd_override_date,
p_dd_financial_inst,
p_dd_cpa_code,
p_dd_file_number,
p_cheque_payment_type,
p_cheque_payment_method,
p_cheque_sort_sequence,
p_cheque_style,
p_start_cheque_number,
p_end_cheque_number,
p_da_data_type,
p_payment_rep_payment_type,
p_payment_rep_payment_method,
p_roe_assignment_set,
p_roe_worksheet_person,
p_roe_mag_media_person,
p_roe_mag_roe_type,
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,
l_ProcessDesc,
l_RequestorUsername,
l_ProcessOwner,
l_workflowprocess,
l_item_type,
l_item_key
);
p_ele_selection_criterion varchar2,
p_ele_is_element_set varchar2,
p_ele_element_set varchar2,
p_ele_is_element_class varchar2,
p_ele_element_class varchar2,
p_ele_is_element_name varchar2,
p_ele_element_name varchar2,
p_ele_employee varchar2,
p_deduction_class varchar2,
p_deduction_name varchar2,
p_deduction_sort_one varchar2,
p_deduction_sort_two varchar2,
p_deduction_sort_three varchar2,
p_reg_suppress_zero varchar2,
p_reg_full_report_ver varchar2,
p_reg_reporting_dim varchar2,
p_reg_sort_one varchar2,
p_reg_sort_two varchar2,
p_reg_sort_three varchar2,
p_reg_employee_page_break varchar2,
p_reg_req_num varchar2,
p_dd_payment_type varchar2,
p_dd_payment_method varchar2,
p_dd_override_date varchar2,
p_dd_financial_inst varchar2,
p_dd_cpa_code varchar2,
p_dd_file_number varchar2,
p_cheque_payment_type varchar2,
p_cheque_payment_method varchar2,
p_cheque_sort_sequence varchar2,
p_cheque_style varchar2,
p_start_cheque_number varchar2,
p_end_cheque_number varchar2,
p_da_data_type varchar2,
p_payment_rep_payment_type varchar2,
p_payment_rep_payment_method varchar2,
p_roe_assignment_set varchar2,
p_roe_worksheet_person varchar2,
p_roe_mag_media_person varchar2,
p_roe_mag_roe_type 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_action_parameter_group varchar2 -- bug 12548555
) is
l_workflowprocess varchar2(100);
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_ele_selection_criterion,
p_ele_is_element_set,
p_ele_element_set,
p_ele_is_element_class,
p_ele_element_class,
p_ele_is_element_name,
p_ele_element_name,
p_ele_employee,
p_deduction_class,
p_deduction_name,
p_deduction_sort_one,
p_deduction_sort_two,
p_deduction_sort_three,
p_reg_suppress_zero,
p_reg_full_report_ver,
p_reg_reporting_dim,
p_reg_sort_one,
p_reg_sort_two,
p_reg_sort_three,
p_reg_employee_page_break,
p_reg_req_num,
p_dd_payment_type,
p_dd_payment_method,
p_dd_override_date,
p_dd_financial_inst,
p_dd_cpa_code,
p_dd_file_number,
p_cheque_payment_type,
p_cheque_payment_method,
p_cheque_sort_sequence,
p_cheque_style,
p_start_cheque_number,
p_end_cheque_number,
p_da_data_type,
p_payment_rep_payment_type,
p_payment_rep_payment_method,
p_roe_assignment_set,
p_roe_worksheet_person,
p_roe_mag_media_person,
p_roe_mag_roe_type,
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_action_parameter_group, --bug 12548555
l_ProcessDesc,
l_RequestorUsername,
l_ProcessOwner,
l_workflowprocess,
l_item_type,
l_item_key
);
p_ele_selection_criterion varchar2,
p_ele_is_element_set varchar2,
p_ele_element_set varchar2,
p_ele_is_element_class varchar2,
p_ele_element_class varchar2,
p_ele_is_element_name varchar2,
p_ele_element_name varchar2,
p_ele_employee varchar2,
p_deduction_class varchar2,
p_deduction_name varchar2,
p_deduction_sort_one varchar2,
p_deduction_sort_two varchar2,
p_deduction_sort_three varchar2,
p_reg_suppress_zero varchar2,
p_reg_full_report_ver varchar2,
p_reg_reporting_dim varchar2,
p_reg_sort_one varchar2,
p_reg_sort_two varchar2,
p_reg_sort_three varchar2,
p_reg_employee_page_break varchar2,
p_reg_req_num varchar2,
p_dd_payment_type varchar2,
p_dd_payment_method varchar2,
p_dd_override_date varchar2,
p_dd_financial_inst varchar2,
p_dd_cpa_code varchar2,
p_dd_file_number varchar2,
p_cheque_payment_type varchar2,
p_cheque_payment_method varchar2,
p_cheque_sort_sequence varchar2,
p_cheque_style varchar2,
p_start_cheque_number varchar2,
p_end_cheque_number varchar2,
p_da_data_type varchar2,
p_payment_rep_payment_type varchar2,
p_payment_rep_payment_method varchar2,
p_roe_assignment_set varchar2,
p_roe_worksheet_person varchar2,
p_roe_mag_media_person varchar2,
p_roe_mag_roe_type 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,
ProcessDesc in varchar2,
RequestorUsername in varchar2,
ProcessOwner in varchar2,
Workflowprocess in varchar2 default null,
item_type in varchar2 default null,
item_key in varchar2
) is
ItemType varchar2(30) := item_type;
select nvl(substr(parameter_value,1,1), 'W')
from pay_action_parameters
where parameter_name = 'PAYROLL_CA_WF_NOTIFY_ACTION';
select period_name
from per_time_periods
where payroll_id = l_payroll_id
and end_date = fnd_date.canonical_to_date(p_date_earned);
select event_group_name
from pay_event_groups
where business_group_id = p_business_group_id
and event_group_id =
to_number(substr(p_retro_event_group,(length('EVT_GRP_ID=')+1)));
select assignment_set_name
from hr_assignment_sets
where assignment_set_id = to_number(p_retropay_assignment_set)
and business_group_id = p_business_group_id;
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_retropay_element_set)
and business_group_id = p_business_group_id;
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_payroll_element_set)
and business_group_id = p_business_group_id;
select assignment_set_name
from hr_assignment_sets
where assignment_set_id = to_number(p_payroll_assignment_set)
and payroll_id = l_payroll_id;
select t.run_type_name
from pay_run_types_f_tl t,
pay_run_types_f r
where r.run_type_id = to_number(p_payroll_run_type)
and r.run_type_id = t.run_type_id
and t.language = userenv('LANG')
and fnd_date.canonical_to_date(p_date_earned)
between r.effective_start_date and r.effective_end_date;
select meaning
from hr_lookups
where lookup_code = p_sdr_reporting_dimension
and lookup_type = 'PAY_CA_REPORT_DIMENSION'
and application_id = 800;
select exception_group_name
from pqp_exception_report_groups
where exception_group_id = to_number(p_exp_group_name);
select exception_report_name
from pqp_exception_reports
where exception_report_id = to_number(p_exp_report_name);
select meaning
from fnd_common_lookups
where lookup_type = 'PQP_VARIANCE_TYPE'
and lookup_code = p_exp_variance_type;
select org_payment_method_name
from pay_org_payment_methods_f_tl
where org_payment_method_id = to_number(p_payment_method_override)
and language = userenv('LANG');
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_ele_element_set)
and element_set_type = 'C';
select classification_name
from pay_element_classifications
where classification_id = to_number(p_ele_element_class);
select element_name
from pay_element_types_f_tl
where element_type_id = to_number(p_ele_element_name)
and language = userenv('LANG');
select full_name||'(Person ID='||person_id||')'
from per_people_f
where person_id = to_number(p_ele_employee)
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
select classification_name
from pay_element_classifications
where classification_id = to_number(p_deduction_class);
select element_name
from pay_element_types_f
where element_type_id = to_number(p_deduction_name)
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
select flv.meaning
from fnd_lookup_values flv, fnd_lookup_types flt
where flv.lookup_code = p_reg_reporting_dim
and flt.lookup_type = 'CA_DIMENSION'
and flt.application_id = 800
and flt.lookup_type = flv.lookup_type;
select payment_type_name
from pay_payment_types
where payment_type_id = to_number(p_cheque_payment_type)
and territory_code = 'CA'
and category = 'CH';
select org_payment_method_name
from pay_org_payment_methods_f_tl
where org_payment_method_id = to_number(p_cheque_payment_method);
select meaning
from hr_lookups
where lookup_code = p_cheque_sort_sequence
and lookup_type = 'CHEQUE_PROCEDURE'
and enabled_flag = 'Y';
select meaning
from hr_lookups
where lookup_code = p_cheque_style
and lookup_type = 'CA_CHEQUE_DEPADV'
and enabled_flag = 'Y';
select meaning
from hr_lookups
where lookup_code = p_da_data_type
and lookup_type = 'DAR_REPORT'
and enabled_flag = 'Y';
select assignment_set_name
from hr_assignment_sets
where assignment_set_id =
to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
select full_name
from per_all_people_f
where person_id = to_number(p_roe_worksheet_person)
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
select full_name
from per_all_people_f
where person_id =
to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
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 period_name
into lv_gtn_period
from per_time_periods
where payroll_id = to_number(p_payroll_id)
and time_period_id = to_number(p_gross_to_net_period);
select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'
into lv_payroll_process
from pay_payroll_actions
where payroll_action_id = to_number(p_payroll_process);
select to_char(sysdate, 'HHSSSS')
into lv_exp_finder_pqp
from dual;
select payroll_name
into lv_payroll_name
from pay_all_payrolls_f
where payroll_id = l_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 = l_consolidation_set_id;
select name
into lv_organization
from per_organization_units
where organization_id = to_number(p_organization)
and business_group_id = p_business_group_id
and fnd_date.canonical_to_date(p_date_earned) between
date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
select location_code||' '||description
into lv_location
from hr_locations
where location_id = to_number(p_location);
select name
into lv_gre_name
from hr_ca_tax_units_v
where tax_unit_id = to_number(p_gre)
and business_group_id = p_business_group_id
and fnd_date.canonical_to_date(p_date_earned) between
date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
select hou.name
into lv_tax_group
from hr_all_organization_units hou,
hr_organization_information hoi
where hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'CLASS'
and hoi.org_information1 = 'CA_TAX_GROUP'
and hou.business_group_id = p_business_group_id
and hou.organization_id = to_number(p_tax_group)
and fnd_date.canonical_to_date(p_date_earned) between
hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
select pcp.account_number
into lv_account_number
from hr_organization_information hoi1,
hr_organization_information hoi2,
pay_ca_pmed_accounts pcp
where hoi1.org_information_context = 'CLASS'
and hoi1.org_information1 = 'CA_PMED'
and hoi1.org_information2 = 'Y'
and hoi1.organization_id = hoi2.organization_id
and pcp.organization_id = hoi1.organization_id
and pcp.business_group_id = p_business_group_id
and pcp.source_id = to_number(p_qhsf_account_number)
and hoi2.org_information1 = 'QC'
and hoi2.org_information_context = 'Provincial Information';
select meaning
into lv_reg_sort_one
from hr_lookups
where lookup_code = p_reg_sort_one
and lookup_type = 'PAY_CA_YE_SORT_CODE';
select meaning
into lv_reg_sort_two
from hr_lookups
where lookup_code = p_reg_sort_two
and lookup_type = 'PAY_CA_YE_SORT_CODE';
select meaning
into lv_reg_sort_three
from hr_lookups
where lookup_code = p_reg_sort_three
and lookup_type = 'PAY_CA_YE_SORT_CODE';
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 lv_orig_system,
lv_orig_system_id,
lv_role_name,
lv_role_display_name
from wf_roles
where name = lv_contact_user_name ;
if (p_ele_selection_criterion is not null)
then
lv_is_element_register := 'Y';
varname(i) := 'SELECT_REPORT_OR_GROUP';
varname(i) := 'SELECTION_CRITERION';
varval(i) := p_ele_selection_criterion;
varval(i) := p_cost_detail_selection;
p_ele_selection_criterion varchar2,
p_ele_is_element_set varchar2,
p_ele_element_set varchar2,
p_ele_is_element_class varchar2,
p_ele_element_class varchar2,
p_ele_is_element_name varchar2,
p_ele_element_name varchar2,
p_ele_employee varchar2,
p_deduction_class varchar2,
p_deduction_name varchar2,
p_deduction_sort_one varchar2,
p_deduction_sort_two varchar2,
p_deduction_sort_three varchar2,
p_reg_suppress_zero varchar2,
p_reg_full_report_ver varchar2,
p_reg_reporting_dim varchar2,
p_reg_sort_one varchar2,
p_reg_sort_two varchar2,
p_reg_sort_three varchar2,
p_reg_employee_page_break varchar2,
p_reg_req_num varchar2,
p_dd_payment_type varchar2,
p_dd_payment_method varchar2,
p_dd_override_date varchar2,
p_dd_financial_inst varchar2,
p_dd_cpa_code varchar2,
p_dd_file_number varchar2,
p_cheque_payment_type varchar2,
p_cheque_payment_method varchar2,
p_cheque_sort_sequence varchar2,
p_cheque_style varchar2,
p_start_cheque_number varchar2,
p_end_cheque_number varchar2,
p_da_data_type varchar2,
p_payment_rep_payment_type varchar2,
p_payment_rep_payment_method varchar2,
p_roe_assignment_set varchar2,
p_roe_worksheet_person varchar2,
p_roe_mag_media_person varchar2,
p_roe_mag_roe_type 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_action_parameter_group varchar2, --bug 12548555
ProcessDesc in varchar2,
RequestorUsername in varchar2,
ProcessOwner in varchar2,
Workflowprocess in varchar2 default null,
item_type in varchar2 default null,
item_key in varchar2
) is
ItemType varchar2(30) := item_type;
select nvl(substr(parameter_value,1,1), 'W')
from pay_action_parameters
where parameter_name = 'PAYROLL_CA_WF_NOTIFY_ACTION';
select period_name
from per_time_periods
where payroll_id = l_payroll_id
and end_date = fnd_date.canonical_to_date(p_date_earned);
select event_group_name
from pay_event_groups
where business_group_id = p_business_group_id
and event_group_id =
to_number(substr(p_retro_event_group,(length('EVT_GRP_ID=')+1)));
select assignment_set_name
from hr_assignment_sets
where assignment_set_id = to_number(p_retropay_assignment_set)
and business_group_id = p_business_group_id;
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_retropay_element_set)
and business_group_id = p_business_group_id;
select prd.retro_definition_id
from pay_retro_definitions prd,
per_business_groups p
where prd.legislation_code = p.legislation_code
and p.business_group_id = p_business_group_id;
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_payroll_element_set)
and business_group_id = p_business_group_id;
select assignment_set_name
from hr_assignment_sets
where assignment_set_id = to_number(p_payroll_assignment_set)
and payroll_id = l_payroll_id;
select t.run_type_name
from pay_run_types_f_tl t,
pay_run_types_f r
where r.run_type_id = to_number(p_payroll_run_type)
and r.run_type_id = t.run_type_id
and t.language = userenv('LANG')
and fnd_date.canonical_to_date(p_date_earned)
between r.effective_start_date and r.effective_end_date;
select meaning
from hr_lookups
where lookup_code = p_sdr_reporting_dimension
and lookup_type = 'PAY_CA_REPORT_DIMENSION'
and application_id = 800;
select exception_group_name
from pqp_exception_report_groups
where exception_group_id = to_number(p_exp_group_name);
select exception_report_name
from pqp_exception_reports
where exception_report_id = to_number(p_exp_report_name);
select meaning
from fnd_common_lookups
where lookup_type = 'PQP_VARIANCE_TYPE'
and lookup_code = p_exp_variance_type;
select org_payment_method_name
from pay_org_payment_methods_f_tl
where org_payment_method_id = to_number(p_payment_method_override)
and language = userenv('LANG');
select element_set_name
from pay_element_sets
where element_set_id = to_number(p_ele_element_set)
and element_set_type = 'C';
select classification_name
from pay_element_classifications
where classification_id = to_number(p_ele_element_class);
select element_name
from pay_element_types_f_tl
where element_type_id = to_number(p_ele_element_name)
and language = userenv('LANG');
select full_name||'(Person ID='||person_id||')'
from per_people_f
where person_id = to_number(p_ele_employee)
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
select classification_name
from pay_element_classifications
where classification_id = to_number(p_deduction_class);
select element_name
from pay_element_types_f
where element_type_id = to_number(p_deduction_name)
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
select flv.meaning
from fnd_lookup_values flv, fnd_lookup_types flt
where flv.lookup_code = p_reg_reporting_dim
and flt.lookup_type = 'CA_DIMENSION'
and flt.application_id = 800
and flt.lookup_type = flv.lookup_type;
select payment_type_name
from pay_payment_types
where payment_type_id = to_number(p_cheque_payment_type)
and territory_code = 'CA'
and category = 'CH';
select org_payment_method_name
from pay_org_payment_methods_f_tl
where org_payment_method_id = to_number(p_cheque_payment_method);
select meaning
from hr_lookups
where lookup_code = p_cheque_sort_sequence
and lookup_type = 'CHEQUE_PROCEDURE'
and enabled_flag = 'Y';
select meaning
from hr_lookups
where lookup_code = p_cheque_style
and lookup_type = 'CA_CHEQUE_DEPADV'
and enabled_flag = 'Y';
select meaning
from hr_lookups
where lookup_code = p_da_data_type
and lookup_type = 'DAR_REPORT'
and enabled_flag = 'Y';
select assignment_set_name
from hr_assignment_sets
where assignment_set_id =
to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
select full_name
from per_all_people_f
where person_id = to_number(p_roe_worksheet_person)
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
select full_name
from per_all_people_f
where person_id =
to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
and fnd_date.canonical_to_date(p_date_earned)
between effective_start_date and effective_end_date;
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 period_name
into lv_gtn_period
from per_time_periods
where payroll_id = to_number(p_payroll_id)
and time_period_id = to_number(p_gross_to_net_period);
select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'
into lv_payroll_process
from pay_payroll_actions
where payroll_action_id = to_number(p_payroll_process);
select to_char(sysdate, 'HHSSSS')
into lv_exp_finder_pqp
from dual;
select payroll_name
into lv_payroll_name
from pay_all_payrolls_f
where payroll_id = l_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 = l_consolidation_set_id;
select name
into lv_organization
from per_organization_units
where organization_id = to_number(p_organization)
and business_group_id = p_business_group_id
and fnd_date.canonical_to_date(p_date_earned) between
date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
select location_code||' '||description
into lv_location
from hr_locations
where location_id = to_number(p_location);
select name
into lv_gre_name
from hr_ca_tax_units_v
where tax_unit_id = to_number(p_gre)
and business_group_id = p_business_group_id
and fnd_date.canonical_to_date(p_date_earned) between
date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
select hou.name
into lv_tax_group
from hr_all_organization_units hou,
hr_organization_information hoi
where hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'CLASS'
and hoi.org_information1 = 'CA_TAX_GROUP'
and hou.business_group_id = p_business_group_id
and hou.organization_id = to_number(p_tax_group)
and fnd_date.canonical_to_date(p_date_earned) between
hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
select pcp.account_number
into lv_account_number
from hr_organization_information hoi1,
hr_organization_information hoi2,
pay_ca_pmed_accounts pcp
where hoi1.org_information_context = 'CLASS'
and hoi1.org_information1 = 'CA_PMED'
and hoi1.org_information2 = 'Y'
and hoi1.organization_id = hoi2.organization_id
and pcp.organization_id = hoi1.organization_id
and pcp.business_group_id = p_business_group_id
and pcp.source_id = to_number(p_qhsf_account_number)
and hoi2.org_information1 = 'QC'
and hoi2.org_information_context = 'Provincial Information';
select meaning
into lv_reg_sort_one
from hr_lookups
where lookup_code = p_reg_sort_one
and lookup_type = 'PAY_CA_YE_SORT_CODE';
select meaning
into lv_reg_sort_two
from hr_lookups
where lookup_code = p_reg_sort_two
and lookup_type = 'PAY_CA_YE_SORT_CODE';
select meaning
into lv_reg_sort_three
from hr_lookups
where lookup_code = p_reg_sort_three
and lookup_type = 'PAY_CA_YE_SORT_CODE';
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 lv_orig_system,
lv_orig_system_id,
lv_role_name,
lv_role_display_name
from wf_roles
where name = lv_contact_user_name ;
if (p_ele_selection_criterion is not null)
then
lv_is_element_register := 'Y';
varname(i) := 'SELECT_REPORT_OR_GROUP';
varname(i) := 'SELECTION_CRITERION';
varval(i) := p_ele_selection_criterion;
varval(i) := p_cost_detail_selection;
select prl_information7
from pay_payrolls_f
where payroll_id = p_payroll_id
and prl_information_category = 'CA'
and fnd_date.canonical_to_date(p_effective_date) between
effective_start_date and effective_end_date;
select org_information1
from hr_organization_information
where org_information_context || '' = 'Contact Information'
and organization_id = p_gre_id;