[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
introduced in the previous update should
have been 801 and not 800
08-AUG-2005 saurgupt 115.5 Modified the proc get_dynamic_tax_unit.
Raised the error if tax_unit_id is not
present for the element being processed.
10-APR-2002 vpandya 115.4 Added get_multi_tax_unit_pay_flag procedure
to get 'Payroll Archiver Level' of the
business group for prepayment.
GRE - Separate Cheque by GRE
TAXGRP - Consolidated Cheque for all GREs.
04-SEP-2002 vpandya 115.3 Added get_dynamic_tax_unit procedure for
Multi GRE functionality.
14-Apr-2000 SSattini 115.1 Changed pay_ca_emp_all_fedtax_info to
pay_ca_emp_all_fedtax_info_v.
07-May-1999 Lwthomps Modified to use the allfed info view.
16-APr-1999 mmukherj 110.0 Created.
*/
--
--
PROCEDURE get_default_jurisdiction(p_asg_act_id number,
p_ee_id number,
p_jurisdiction in out nocopy varchar2)
IS
l_geocode varchar2(15);
Select employment_province, geocode
from pay_ca_emp_all_fedtax_info_v cft,
pay_assignment_actions paa
where cft.assignment_id = paa.assignment_id
and paa.assignment_action_id = p_asg_act_id;
select substr(run_type_name,1,instr(run_type_name,' ')-1)
from pay_run_types_f
where run_type_id = cp_run_type_id;
select segment1 T4_RL1_GRE
,segment11 T4A_RL1_GRE
,segment12 T4A_RL2_GRE
from hr_soft_coding_keyflex hsck
,per_all_assignments_f paf
,pay_assignment_actions paa
,pay_payroll_actions ppa
where paa.assignment_action_id = cp_asg_act_id
and ppa.payroll_action_id = paa.payroll_action_id
and paf.assignment_id = paa.assignment_id
and ppa.effective_date between paf.effective_start_date
and paf.effective_end_date
and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;
select hoi.org_information5
from hr_organization_information hoi
where hoi.organization_id = cp_tax_unit_id
and hoi.org_information_context = 'Canada Employer Identification';
select decode(segment1, NULL, 0, 1 ) +
decode(segment11, NULL, 0, 1 ) +
decode(segment12, NULL, 0, 1 ) tot_no_of_tu
,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
from hr_soft_coding_keyflex hsck
,per_all_assignments_f paf
,pay_assignment_actions paa
,pay_payroll_actions ppa
where paa.assignment_action_id = cp_asg_act_id
and ppa.payroll_action_id = paa.payroll_action_id
and paf.assignment_id = paa.assignment_id
and ppa.effective_date between paf.effective_start_date
and paf.effective_end_date
and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;
select org_information1
into l_reporting_level
from hr_organization_information
where org_information_context = 'Payroll Archiver Level'
and organization_id = p_bus_grp;
SELECT assignment_number
FROM per_assignments_f paf, pay_assignment_actions paa
WHERE paa.assignment_action_id = p_asg_action_id
and paa.assignment_id = paf.assignment_id; */
SELECT
SYSDATE,
NVL(overriding_dd_date,effective_date)
FROM
pay_payroll_actions
WHERE
payroll_action_id = p_payroll_action_id;
SELECT
decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),
'TD', to_char(l_direct_deposit_date,'DDMMYY'),
'CPA','0'||to_char(l_direct_deposit_date,'YYDDD'),
'CIBC',to_char(l_direct_deposit_date,'YYMMDD'))
INTO
l_dd_date
FROM
DUAL;
SELECT
decode(l_dd_type, 'NOVA_SCOT',to_char(l_payment_date,'YYDDD'),
'TD', to_char(l_payment_date,'DDMMYY'),
'CPA','0'||to_char(l_payment_date,'YYDDD'),
'CIBC',to_char(l_payment_date,'YYMMDD'))
INTO
l_payment_date1
FROM
DUAL;
SELECT rule_mode
FROM pay_legislation_rules
WHERE legislation_code = 'CA'
and rule_type = 'S';
SELECT target.SEGMENT4
FROM /* route for SCL keyflex - assignment level */
hr_soft_coding_keyflex target,
per_all_assignments_f ASSIGN
WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
AND ASSIGN.effective_end_date
AND ASSIGN.assignment_id = p_assignment_id
AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
AND target.enabled_flag = 'Y'
AND target.id_flex_num = p_id_flex_num;
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,'CA') = 'CA'
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,'CA') = 'CA'
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
legislative_parameters,
business_group_id,
org_payment_method_id
FROM
pay_payroll_actions
WHERE
payroll_action_id = pactid;