eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL2_REG dependencies on PAY_CA_RL2_REG

Line 1: package body pay_ca_rl2_reg as

1: package body pay_ca_rl2_reg as
2: /* $Header: pycarl2.pkb 120.4.12000000.3 2007/08/08 05:26:53 amigarg noship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5: --

Line 71: l_taxyear := '''' || pay_ca_rl2_reg.get_parameter('TAX_YEAR',leg_param) || '''';

67: into leg_param
68: from pay_payroll_actions ppa
69: where ppa.payroll_action_id = pactid;
70:
71: l_taxyear := '''' || pay_ca_rl2_reg.get_parameter('TAX_YEAR',leg_param) || '''';
72: l_pre_org_id := '''' || pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',leg_param) || '''';
73:
74: sqlstr := 'select distinct to_number(paa_arch.serial_number)
75: from pay_action_information pai1,

Line 72: l_pre_org_id := '''' || pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',leg_param) || '''';

68: from pay_payroll_actions ppa
69: where ppa.payroll_action_id = pactid;
70:
71: l_taxyear := '''' || pay_ca_rl2_reg.get_parameter('TAX_YEAR',leg_param) || '''';
72: l_pre_org_id := '''' || pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',leg_param) || '''';
73:
74: sqlstr := 'select distinct to_number(paa_arch.serial_number)
75: from pay_action_information pai1,
76: pay_action_information pai2,

Line 92: and paa_arch.serial_number = nvl(pay_ca_rl2_reg.get_parameter(''PER_ID'',ppa_reg.legislative_parameters),

88: and ppa_arch.payroll_action_id = pai1.action_context_id
89: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
90: and paa_arch.assignment_action_id = pai2.action_context_id
91: and paa_arch.action_status = ''C''
92: and paa_arch.serial_number = nvl(pay_ca_rl2_reg.get_parameter(''PER_ID'',ppa_reg.legislative_parameters),
93: paa_arch.serial_number)
94: order by to_number(paa_arch.serial_number)';
95:
96: hr_utility.trace('End of range_cursor 2 ');

Line 319: l_year := pay_ca_rl2_reg.get_parameter('TAX_YEAR',l_legislative_parameters);

315: where payroll_action_id = pactid;
316:
317: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
318:
319: l_year := pay_ca_rl2_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
320: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
321: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
322: l_asg_set_id := pay_ca_rl2_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
323: lv_per_id := pay_ca_rl2_reg.get_parameter('PER_ID',l_legislative_parameters);

Line 322: l_asg_set_id := pay_ca_rl2_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);

318:
319: l_year := pay_ca_rl2_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
320: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
321: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
322: l_asg_set_id := pay_ca_rl2_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
323: lv_per_id := pay_ca_rl2_reg.get_parameter('PER_ID',l_legislative_parameters);
324:
325: l_rlreg_pre_org_id := pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',l_legislative_parameters);
326:

Line 323: lv_per_id := pay_ca_rl2_reg.get_parameter('PER_ID',l_legislative_parameters);

319: l_year := pay_ca_rl2_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
320: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
321: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
322: l_asg_set_id := pay_ca_rl2_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
323: lv_per_id := pay_ca_rl2_reg.get_parameter('PER_ID',l_legislative_parameters);
324:
325: l_rlreg_pre_org_id := pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',l_legislative_parameters);
326:
327: if l_rlreg_pre_org_id is NULL then

Line 325: l_rlreg_pre_org_id := pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',l_legislative_parameters);

321: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
322: l_asg_set_id := pay_ca_rl2_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
323: lv_per_id := pay_ca_rl2_reg.get_parameter('PER_ID',l_legislative_parameters);
324:
325: l_rlreg_pre_org_id := pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',l_legislative_parameters);
326:
327: if l_rlreg_pre_org_id is NULL then
328: open c_all_pres;
329: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');

Line 604: decode(pay_ca_rl2_reg.get_parameter(''P_S1'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,

600: where paaf2.assignment_id = paf.assignment_id
601: and paaf2.effective_start_date <= ppa1.effective_date
602: )
603: order by
604: decode(pay_ca_rl2_reg.get_parameter(''P_S1'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
605: ''RL1_ORG'',hou1.name,
606: ''RL1_LOC'',loc.location_code,null)
607: ,decode(pay_ca_rl2_reg.get_parameter(''P_S2'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
608: ''RL1_ORG'',hou1.name,

Line 607: ,decode(pay_ca_rl2_reg.get_parameter(''P_S2'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,

603: order by
604: decode(pay_ca_rl2_reg.get_parameter(''P_S1'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
605: ''RL1_ORG'',hou1.name,
606: ''RL1_LOC'',loc.location_code,null)
607: ,decode(pay_ca_rl2_reg.get_parameter(''P_S2'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
608: ''RL1_ORG'',hou1.name,
609: ''RL1_LOC'',loc.location_code,null)
610: ,decode(pay_ca_rl2_reg.get_parameter(''P_S3'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
611: ''RL1_ORG'',hou1.name,

Line 610: ,decode(pay_ca_rl2_reg.get_parameter(''P_S3'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,

606: ''RL1_LOC'',loc.location_code,null)
607: ,decode(pay_ca_rl2_reg.get_parameter(''P_S2'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
608: ''RL1_ORG'',hou1.name,
609: ''RL1_LOC'',loc.location_code,null)
610: ,decode(pay_ca_rl2_reg.get_parameter(''P_S3'',ppa1.legislative_parameters), ''RL1_PRE'',hou.name,
611: ''RL1_ORG'',hou1.name,
612: ''RL1_LOC'',loc.location_code,null)
613: ,ppf.last_name,ppf.first_name';
614:

Line 726: end pay_ca_rl2_reg;

722: return addr;
723:
724: end get_primary_address;
725:
726: end pay_ca_rl2_reg;