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_EOY_T4_AMEND_ARCH dependencies on PAY_CA_EOY_T4_AMEND_ARCH

Line 1: PACKAGE BODY pay_ca_eoy_t4_amend_arch AS

1: PACKAGE BODY pay_ca_eoy_t4_amend_arch AS
2: /* $Header: pycat4ca.pkb 120.2 2011/09/06 06:51:34 abellur ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4_amend_arch

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ca_eoy_t4_amend_arch
21:
22: Description : This procedure is used by T4 Amendment Pre-Process
23: to archive data for T4 Amendment Paper Report.
24:

Line 61: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_arch';

57: CURSOR, if RANGE_PERSON_ID
58: is enabled.
59: *****************************************************************************/
60:
61: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_arch';
62: gv_procedure_name VARCHAR2(100);
63:
64: /*****************************************************************************
65: Name : get_payroll_action_info

Line 84: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

80: ,p_year out nocopy varchar2
81: )
82: IS
83: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
84: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
85: 'TRANSFER_GRE',ppa.legislative_parameters)),
86: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
87: 'PER_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

Line 86: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

82: IS
83: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
84: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
85: 'TRANSFER_GRE',ppa.legislative_parameters)),
86: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
87: 'PER_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
89: 'SSN',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

Line 88: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

84: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
85: 'TRANSFER_GRE',ppa.legislative_parameters)),
86: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
87: 'PER_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
89: 'SSN',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
91: 'ASG_SET',ppa.legislative_parameters)),
92: to_char(effective_date,'YYYY') ,

Line 90: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

86: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
87: 'PER_ID',ppa.legislative_parameters)),
88: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
89: 'SSN',ppa.legislative_parameters)),
90: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
91: 'ASG_SET',ppa.legislative_parameters)),
92: to_char(effective_date,'YYYY') ,
93: effective_date,
94: start_date,

Line 172: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

168: -- Added for bug 10399514
169: )
170: IS
171: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
172: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
173: 'TRANSFER_GRE',ppa.legislative_parameters)),
174: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
175: 'PER_ID',ppa.legislative_parameters)),
176: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

Line 174: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

170: IS
171: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
172: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
173: 'TRANSFER_GRE',ppa.legislative_parameters)),
174: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
175: 'PER_ID',ppa.legislative_parameters)),
176: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
177: 'SSN',ppa.legislative_parameters)),
178: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

Line 176: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

172: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
173: 'TRANSFER_GRE',ppa.legislative_parameters)),
174: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
175: 'PER_ID',ppa.legislative_parameters)),
176: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
177: 'SSN',ppa.legislative_parameters)),
178: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
179: 'ASG_SET',ppa.legislative_parameters)),
180: to_char(effective_date,'YYYY') ,

Line 178: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

174: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
175: 'PER_ID',ppa.legislative_parameters)),
176: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
177: 'SSN',ppa.legislative_parameters)),
178: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
179: 'ASG_SET',ppa.legislative_parameters)),
180: to_char(effective_date,'YYYY') ,
181: effective_date,
182: start_date,

Line 425: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',

421: and cp_end_person
422: and ppa.report_type = 'T4'
423: and to_char(ppa.effective_date,'YYYY') = lv_year
424: and ppa.business_group_id+0 = ln_business_group_id
425: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',
426: ppa.legislative_parameters)) = ln_tax_unit_id
427: and paa.payroll_action_id = ppa.payroll_action_id
428: and paa.action_status = 'C'
429: and paf.person_id = to_number(paa.serial_number);

Line 454: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',

450: and ppr.person_id = paf.person_id
451: and ppa.report_type = 'T4'
452: and to_char(ppa.effective_date,'YYYY') = lv_year
453: and ppa.business_group_id+0 = ln_business_group_id
454: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',
455: ppa.legislative_parameters)) = ln_tax_unit_id
456: and paa.payroll_action_id = ppa.payroll_action_id
457: and paa.action_status = 'C'
458: and paf.person_id = to_number(paa.serial_number);

Line 478: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',

474: and ppa.payroll_action_id = paa.payroll_action_id
475: and ppa.effective_date = cp_effective_date
476: and ppa.report_type in ('T4', 'CAEOY_T4_AMEND_PP')
477: and ppa.business_group_id+0 = ln_business_group_id
478: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',
479: ppa.legislative_parameters)) = cp_tax_unit_id
480: and to_number(paa.serial_number) = cp_person_id
481: order by paa.assignment_action_id desc;
482:

Line 734: end pay_ca_eoy_t4_amend_arch;

730: null;
731:
732:
733:
734: end pay_ca_eoy_t4_amend_arch;