APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on PAY_CA_EOY_RL2_AMEND_ARCH

Line 1: PACKAGE BODY pay_ca_eoy_rl2_amend_arch AS

1: PACKAGE BODY pay_ca_eoy_rl2_amend_arch AS
2: /* $Header: pycarl2ca.pkb 120.1 2006/10/11 20:44:08 meshah noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl2_amend_arch

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

Line 34: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl2_amend_arch';

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

Line 57: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

53: ,p_asg_set out nocopy number
54: ,p_year out nocopy varchar2)
55: IS
56: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
57: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
58: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
59: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
60: 'PER_ID',ppa.legislative_parameters)),
61: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

Line 59: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

55: IS
56: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
57: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
58: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
59: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
60: 'PER_ID',ppa.legislative_parameters)),
61: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
62: 'SSN',ppa.legislative_parameters)),
63: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

Line 61: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

57: select to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
58: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
59: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
60: 'PER_ID',ppa.legislative_parameters)),
61: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
62: 'SSN',ppa.legislative_parameters)),
63: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(
64: 'ASG_SET',ppa.legislative_parameters)),
65: to_char(effective_date,'YYYY') ,

Line 63: to_number(pay_ca_eoy_rl2_amend_arch.get_parameter(

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

Line 281: and pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

277: and cp_end_person
278: and ppa.report_type = 'RL2'
279: and to_char(ppa.effective_date,'YYYY') = lv_year
280: and ppa.business_group_id+0 = ln_business_group_id
281: and pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
282: ppa.legislative_parameters) = to_char(ln_pre_org_id)
283: and paa.payroll_action_id = ppa.payroll_action_id
284: and paa.action_status = 'C'
285: and paf.person_id = to_number(paa.serial_number);

Line 299: and pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

295: paa.assignment_action_id
296: from pay_payroll_actions ppa,
297: pay_assignment_actions paa
298: where to_number(paa.serial_number) = cp_person_id
299: and pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
300: ppa.legislative_parameters) = to_char(cp_pre_org_id)
301: and paa.action_status = 'C'
302: and ppa.business_group_id+0 = ln_business_group_id
303: and ppa.payroll_action_id = paa.payroll_action_id

Line 507: end pay_ca_eoy_rl2_amend_arch;

503:
504: Begin
505: null;
506:
507: end pay_ca_eoy_rl2_amend_arch;