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.

[Home] [Help]

APPS.PAY_CA_EOY_T4A_AMEND_ARCH dependencies on PAY_CA_EOY_T4A_AMEND_ARCH

Line 1: PACKAGE BODY pay_ca_eoy_t4a_amend_arch AS

1: PACKAGE BODY pay_ca_eoy_t4a_amend_arch AS
2: /* $Header: pycat4aca.pkb 120.3 2012/01/19 08:47:37 rpahune ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_t4a_amend_arch

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

Line 41: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_arch';

37: c_selected_asg_set CURSOR,
38: if RANGE_PERSON_ID is enabled.
39: *****************************************************************************/
40:
41: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_arch';
42: gv_procedure_name VARCHAR2(100);
43:
44:
45: /*****************************************************************************

Line 64: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

60: ,p_asg_set out nocopy number
61: ,p_year out nocopy varchar2)
62: IS
63: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
64: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
65: 'TRANSFER_GRE',ppa.legislative_parameters)),
66: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
67: 'PER_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

Line 66: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

62: IS
63: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
64: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
65: 'TRANSFER_GRE',ppa.legislative_parameters)),
66: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
67: 'PER_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
69: 'ASG_SET',ppa.legislative_parameters)),
70: to_char(effective_date,'YYYY') ,

Line 68: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

64: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
65: 'TRANSFER_GRE',ppa.legislative_parameters)),
66: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
67: 'PER_ID',ppa.legislative_parameters)),
68: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
69: 'ASG_SET',ppa.legislative_parameters)),
70: to_char(effective_date,'YYYY') ,
71: effective_date,
72: start_date,

Line 148: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

144: -- Added for bug 10399514
145: )
146: IS
147: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
148: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
149: 'TRANSFER_GRE',ppa.legislative_parameters)),
150: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
151: 'PER_ID',ppa.legislative_parameters)),
152: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

Line 150: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

146: IS
147: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
148: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
149: 'TRANSFER_GRE',ppa.legislative_parameters)),
150: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
151: 'PER_ID',ppa.legislative_parameters)),
152: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
153: 'ASG_SET',ppa.legislative_parameters)),
154: to_char(effective_date,'YYYY') ,

Line 152: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

148: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
149: 'TRANSFER_GRE',ppa.legislative_parameters)),
150: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
151: 'PER_ID',ppa.legislative_parameters)),
152: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
153: 'ASG_SET',ppa.legislative_parameters)),
154: to_char(effective_date,'YYYY') ,
155: effective_date,
156: start_date,

Line 394: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',

390: and cp_end_person
391: and ppa.report_type = 'T4A'
392: and to_char(ppa.effective_date,'YYYY') = lv_year
393: and ppa.business_group_id+0 = ln_business_group_id
394: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',
395: ppa.legislative_parameters)) = ln_tax_unit_id
396: and paa.payroll_action_id = ppa.payroll_action_id
397: and paa.action_status = 'C'
398: and paf.person_id = to_number(paa.serial_number);

Line 423: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',

419: and ppr.person_id = paf.person_id
420: and ppa.report_type = 'T4A'
421: and to_char(ppa.effective_date,'YYYY') = lv_year
422: and ppa.business_group_id+0 = ln_business_group_id
423: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',
424: ppa.legislative_parameters)) = ln_tax_unit_id
425: and paa.payroll_action_id = ppa.payroll_action_id
426: and paa.action_status = 'C'
427: and paf.person_id = to_number(paa.serial_number);

Line 447: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',

443: and ppa.business_group_id+0 = ln_business_group_id
444: and ppa.payroll_action_id = paa.payroll_action_id
445: and ppa.effective_date = cp_effective_date
446: and ppa.report_type in ('T4A', 'CAEOY_T4A_AMEND_PP')
447: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',
448: ppa.legislative_parameters)) = cp_tax_unit_id
449: and to_number(paa.serial_number) = cp_person_id
450: order by paa.assignment_action_id desc;
451:

Line 705: end pay_ca_eoy_t4a_amend_arch;

701: null;
702:
703:
704:
705: end pay_ca_eoy_t4a_amend_arch;