APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PAY_CA_EOY_RL1_AMEND_ARCH

Line 1: PACKAGE BODY pay_ca_eoy_rl1_amend_arch AS

1: PACKAGE BODY pay_ca_eoy_rl1_amend_arch AS
2: /* $Header: pycarl1ca.pkb 120.1 2006/10/11 20:43:46 meshah noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl1_amend_arch

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

Line 44: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl1_amend_arch';

40: cursor queries.
41:
42: *****************************************************************************/
43:
44: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl1_amend_arch';
45: gv_procedure_name VARCHAR2(100);
46:
47:
48: /*****************************************************************************

Line 67: select to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(

63: ,p_asg_set out nocopy number
64: ,p_year out nocopy varchar2)
65: IS
66: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
67: select to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
68: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
69: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
70: 'PER_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(

Line 69: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(

65: IS
66: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
67: select to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
68: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
69: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
70: 'PER_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
72: 'SSN',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(

Line 71: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(

67: select to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
68: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
69: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
70: 'PER_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
72: 'SSN',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
74: 'ASG_SET',ppa.legislative_parameters)),
75: to_char(effective_date,'YYYY') ,

Line 73: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(

69: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
70: 'PER_ID',ppa.legislative_parameters)),
71: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
72: 'SSN',ppa.legislative_parameters)),
73: to_number(pay_ca_eoy_rl1_amend_arch.get_parameter(
74: 'ASG_SET',ppa.legislative_parameters)),
75: to_char(effective_date,'YYYY') ,
76: effective_date,
77: start_date,

Line 291: and pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

287: and cp_end_person
288: and ppa.report_type = 'RL1'
289: and to_char(ppa.effective_date,'YYYY') = lv_year
290: and ppa.business_group_id+0 = ln_business_group_id
291: and pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
292: ppa.legislative_parameters) = to_char(ln_pre_org_id)
293: and paa.payroll_action_id = ppa.payroll_action_id
294: and paa.action_status = 'C'
295: and paf.person_id = to_number(paa.serial_number);

Line 309: and pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

305: paa.assignment_action_id
306: from pay_payroll_actions ppa,
307: pay_assignment_actions paa
308: where to_number(paa.serial_number) = cp_person_id
309: and pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
310: ppa.legislative_parameters) = to_char(cp_pre_org_id)
311: and paa.action_status = 'C'
312: and ppa.business_group_id+0 = ln_business_group_id
313: and ppa.payroll_action_id = paa.payroll_action_id

Line 517: end pay_ca_eoy_rl1_amend_arch;

513: Begin
514: --hr_utility.trace_on(null,'RL1AMENDPP');
515: null;
516:
517: end pay_ca_eoy_rl1_amend_arch;