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.1 2006/10/11 20:39:43 meshah noship $ */
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 55: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_arch';

51: 11-OCT-2006 meshah 115.8 5528944 Added order by clause in the range
52: cursor queries.
53: *****************************************************************************/
54:
55: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4_amend_arch';
56: gv_procedure_name VARCHAR2(100);
57:
58: /*****************************************************************************
59: Name : get_payroll_action_info

Line 78: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

74: ,p_year out nocopy varchar2
75: )
76: IS
77: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
78: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
79: 'TRANSFER_GRE',ppa.legislative_parameters)),
80: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
81: 'PER_ID',ppa.legislative_parameters)),
82: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

Line 80: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

76: IS
77: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
78: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
79: 'TRANSFER_GRE',ppa.legislative_parameters)),
80: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
81: 'PER_ID',ppa.legislative_parameters)),
82: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
83: 'SSN',ppa.legislative_parameters)),
84: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

Line 82: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

78: select to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
79: 'TRANSFER_GRE',ppa.legislative_parameters)),
80: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
81: 'PER_ID',ppa.legislative_parameters)),
82: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
83: 'SSN',ppa.legislative_parameters)),
84: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
85: 'ASG_SET',ppa.legislative_parameters)),
86: to_char(effective_date,'YYYY') ,

Line 84: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(

80: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
81: 'PER_ID',ppa.legislative_parameters)),
82: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
83: 'SSN',ppa.legislative_parameters)),
84: to_number(pay_ca_eoy_t4_amend_arch.get_parameter(
85: 'ASG_SET',ppa.legislative_parameters)),
86: to_char(effective_date,'YYYY') ,
87: effective_date,
88: start_date,

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

297: and cp_end_person
298: and ppa.report_type = 'T4'
299: and to_char(ppa.effective_date,'YYYY') = lv_year
300: and ppa.business_group_id+0 = ln_business_group_id
301: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',
302: ppa.legislative_parameters)) = ln_tax_unit_id
303: and paa.payroll_action_id = ppa.payroll_action_id
304: and paa.action_status = 'C'
305: and paf.person_id = to_number(paa.serial_number);

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

321: and ppa.payroll_action_id = paa.payroll_action_id
322: and ppa.effective_date = cp_effective_date
323: and ppa.report_type in ('T4', 'CAEOY_T4_AMEND_PP')
324: and ppa.business_group_id+0 = ln_business_group_id
325: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter('TRANSFER_GRE',
326: ppa.legislative_parameters)) = cp_tax_unit_id
327: and to_number(paa.serial_number) = cp_person_id
328: order by paa.assignment_action_id desc;
329:

Line 528: end pay_ca_eoy_t4_amend_arch;

524: null;
525:
526:
527:
528: end pay_ca_eoy_t4_amend_arch;