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.1 2006/10/11 20:40:13 meshah noship $ */
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 36: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_arch';

32: 11-OCT-2006 meshah 115.2 5528944 Added order by clause in the range
33: cursor queries.
34: *****************************************************************************/
35:
36: gv_package VARCHAR2(100) := 'pay_ca_eoy_t4a_amend_arch';
37: gv_procedure_name VARCHAR2(100);
38:
39:
40: /*****************************************************************************

Line 59: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

55: ,p_asg_set out nocopy number
56: ,p_year out nocopy varchar2)
57: IS
58: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
59: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
60: 'TRANSFER_GRE',ppa.legislative_parameters)),
61: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
62: 'PER_ID',ppa.legislative_parameters)),
63: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

Line 61: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

57: IS
58: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
59: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
60: 'TRANSFER_GRE',ppa.legislative_parameters)),
61: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
62: 'PER_ID',ppa.legislative_parameters)),
63: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
64: 'ASG_SET',ppa.legislative_parameters)),
65: to_char(effective_date,'YYYY') ,

Line 63: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(

59: select to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
60: 'TRANSFER_GRE',ppa.legislative_parameters)),
61: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
62: 'PER_ID',ppa.legislative_parameters)),
63: to_number(pay_ca_eoy_t4a_amend_arch.get_parameter(
64: 'ASG_SET',ppa.legislative_parameters)),
65: to_char(effective_date,'YYYY') ,
66: effective_date,
67: start_date,

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

273: and cp_end_person
274: and ppa.report_type = 'T4A'
275: and to_char(ppa.effective_date,'YYYY') = lv_year
276: and ppa.business_group_id+0 = ln_business_group_id
277: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',
278: ppa.legislative_parameters)) = ln_tax_unit_id
279: and paa.payroll_action_id = ppa.payroll_action_id
280: and paa.action_status = 'C'
281: and paf.person_id = to_number(paa.serial_number);

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

297: and ppa.business_group_id+0 = ln_business_group_id
298: and ppa.payroll_action_id = paa.payroll_action_id
299: and ppa.effective_date = cp_effective_date
300: and ppa.report_type in ('T4A', 'CAEOY_T4A_AMEND_PP')
301: and to_number(pay_ca_eoy_t4a_amend_arch.get_parameter('TRANSFER_GRE',
302: ppa.legislative_parameters)) = cp_tax_unit_id
303: and to_number(paa.serial_number) = cp_person_id
304: order by paa.assignment_action_id desc;
305:

Line 510: end pay_ca_eoy_t4a_amend_arch;

506: null;
507:
508:
509:
510: end pay_ca_eoy_t4a_amend_arch;