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.

APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PAY_CA_EOY_RL1_AMEND_REG

Line 1: PACKAGE BODY pay_ca_eoy_rl1_amend_reg AS

1: PACKAGE BODY pay_ca_eoy_rl1_amend_reg AS
2: /* $Header: pycarl1cr.pkb 120.19.12020000.2 2012/12/31 12:48:01 rgottipa ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl1_amend_reg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ca_eoy_rl1_amend_reg
21:
22: Description : This Package is used by RL1 Amendment Register
23: and RL1 Amendment Paper Reports.
24:

Line 94: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl1_amend_reg';

90: 'paper' option.
91:
92: *****************************************************************************/
93:
94: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl1_amend_reg';
95: gv_procedure_name VARCHAR2(100);
96:
97: /*****************************************************************************
98: Name : get_payroll_action_info

Line 119: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

115: ,p_report_type out nocopy varchar2
116: )
117: IS
118: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
119: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
120: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
121: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
122: 'PER_ID',ppa.legislative_parameters)),
123: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 121: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

117: IS
118: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
119: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
120: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
121: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
122: 'PER_ID',ppa.legislative_parameters)),
123: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
124: 'ASG_SET_ID',ppa.legislative_parameters)),
125: pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 123: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

119: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
120: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
121: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
122: 'PER_ID',ppa.legislative_parameters)),
123: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
124: 'ASG_SET_ID',ppa.legislative_parameters)),
125: pay_ca_eoy_rl1_amend_reg.get_parameter(
126: 'MODE',ppa.legislative_parameters),
127: effective_date,

Line 125: pay_ca_eoy_rl1_amend_reg.get_parameter(

121: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
122: 'PER_ID',ppa.legislative_parameters)),
123: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
124: 'ASG_SET_ID',ppa.legislative_parameters)),
125: pay_ca_eoy_rl1_amend_reg.get_parameter(
126: 'MODE',ppa.legislative_parameters),
127: effective_date,
128: start_date,
129: business_group_id,

Line 197: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

193: ,p_print_term out nocopy varchar2
194: )
195: IS
196: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
197: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
198: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
199: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
200: 'PER_ID',ppa.legislative_parameters)),
201: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 199: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

195: IS
196: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
197: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
198: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
199: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
200: 'PER_ID',ppa.legislative_parameters)),
201: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
202: 'ASG_SET_ID',ppa.legislative_parameters)),
203: pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 201: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

197: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
198: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
199: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
200: 'PER_ID',ppa.legislative_parameters)),
201: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
202: 'ASG_SET_ID',ppa.legislative_parameters)),
203: pay_ca_eoy_rl1_amend_reg.get_parameter(
204: 'MODE',ppa.legislative_parameters),
205: effective_date,

Line 203: pay_ca_eoy_rl1_amend_reg.get_parameter(

199: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
200: 'PER_ID',ppa.legislative_parameters)),
201: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
202: 'ASG_SET_ID',ppa.legislative_parameters)),
203: pay_ca_eoy_rl1_amend_reg.get_parameter(
204: 'MODE',ppa.legislative_parameters),
205: effective_date,
206: start_date,
207: business_group_id,

Line 211: pay_ca_eoy_rl1_amend_reg.get_parameter(

207: business_group_id,
208: report_type,
209: report_qualifier,
210: report_category,
211: pay_ca_eoy_rl1_amend_reg.get_parameter(
212: 'PRINT_TERM',ppa.legislative_parameters)
213: from pay_payroll_actions ppa
214: where ppa.payroll_action_id = cp_payroll_action_id;
215:

Line 457: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

453: and cp_end_person
454: and ppa_arch.business_group_id = ln_business_group_id
455: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
456: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
457: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
458: ppa_arch.legislative_parameters) =
459: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
460: ppa_arch.legislative_parameters))
461: and paa_arch.action_status = 'C'

Line 459: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

455: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
456: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
457: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
458: ppa_arch.legislative_parameters) =
459: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
460: ppa_arch.legislative_parameters))
461: and paa_arch.action_status = 'C'
462: and ppa_arch.effective_date = cp_effective_date
463: and paf.person_id = to_number(paa_arch.serial_number);

Line 485: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

481: --and cp_end_person
482: and ppa_arch.business_group_id = ln_business_group_id
483: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
484: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
485: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
486: ppa_arch.legislative_parameters) =
487: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
488: ppa_arch.legislative_parameters))
489: and paa_arch.action_status = 'C'

Line 487: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

483: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
484: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
485: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
486: ppa_arch.legislative_parameters) =
487: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
488: ppa_arch.legislative_parameters))
489: and paa_arch.action_status = 'C'
490: and ppa_arch.effective_date = cp_effective_date
491: and paf.person_id = to_number(paa_arch.serial_number)

Line 580: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

576: ,cp_business_group_id in number) is
577: select ppa.report_type,
578: paa.assignment_id,
579: paa.assignment_action_id,
580: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
581: ppa.legislative_parameters),
582: paf.effective_end_date
583: from pay_payroll_actions ppa,
584: pay_assignment_actions paa,

Line 588: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

584: pay_assignment_actions paa,
585: per_assignments_f paf
586: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
587: and paa.assignment_id = paf.assignment_id
588: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
589: ppa.legislative_parameters) =
590: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
591: ppa.legislative_parameters))
592: and paa.action_status = 'C'

Line 590: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

586: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
587: and paa.assignment_id = paf.assignment_id
588: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
589: ppa.legislative_parameters) =
590: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
591: ppa.legislative_parameters))
592: and paa.action_status = 'C'
593: and ppa.payroll_action_id = paa.payroll_action_id
594: and ppa.effective_date = cp_effective_date

Line 612: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))

608: AND pact.payroll_action_id = passt.payroll_action_id
609: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
610: AND passt.assignment_action_id = pail.locking_action_id
611: AND passt.assignment_id=paf.assignment_id
612: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
613: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
614: AND (pail.locked_action_id = paa.assignment_action_id
615: OR paa.assignment_action_id < passt.assignment_action_id))
616: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,

Line 613: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

609: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
610: AND passt.assignment_action_id = pail.locking_action_id
611: AND passt.assignment_id=paf.assignment_id
612: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
613: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
614: AND (pail.locked_action_id = paa.assignment_action_id
615: OR paa.assignment_action_id < passt.assignment_action_id))
616: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
617: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

Line 617: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

613: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
614: AND (pail.locked_action_id = paa.assignment_action_id
615: OR paa.assignment_action_id < passt.assignment_action_id))
616: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
617: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
618: ppa.legislative_parameters), --Bug 9133270
619: paf.effective_end_date
620: order by paa.assignment_action_id desc; /*Need to have this to ensure the latest archive assignment_action_id is considered*/
621:

Line 629: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

625: ,cp_business_group_id in number) is
626: select ppa.report_type,
627: paa.assignment_id,
628: paa.assignment_action_id,
629: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
630: ppa.legislative_parameters)
631: from pay_payroll_actions ppa,
632: pay_assignment_actions paa
633: where paa.serial_number = to_char(cp_person_id)

Line 634: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

630: ppa.legislative_parameters)
631: from pay_payroll_actions ppa,
632: pay_assignment_actions paa
633: where paa.serial_number = to_char(cp_person_id)
634: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
635: ppa.legislative_parameters) =
636: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
637: ppa.legislative_parameters))
638: and paa.action_status = 'C'

Line 636: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

632: pay_assignment_actions paa
633: where paa.serial_number = to_char(cp_person_id)
634: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
635: ppa.legislative_parameters) =
636: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
637: ppa.legislative_parameters))
638: and paa.action_status = 'C'
639: and ppa.business_group_id = cp_business_group_id
640: and ppa.payroll_action_id = paa.payroll_action_id

Line 649: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

645: where paf.assignment_id = paa.assignment_id
646: and paf.effective_start_date <= cp_effective_date
647: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
648: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
649: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
650: ppa.legislative_parameters) --Bug 9133270
651: order by paa.assignment_action_id desc;/*Need to have this to ensure the latest archive assignment_action_id is considered*/
652:
653: CURSOR get_reprint_rl1_amend_dtls (cp_person_id in number

Line 660: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

656: ,cp_business_group_id in number) is
657: select ppa.report_type,
658: paa.assignment_id,
659: paa.assignment_action_id,
660: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
661: ppa.legislative_parameters),
662: paf.effective_end_date
663: from pay_payroll_actions ppa,
664: pay_assignment_actions paa,

Line 668: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

664: pay_assignment_actions paa,
665: per_assignments_f paf
666: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
667: and paa.assignment_id = paf.assignment_id
668: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
669: ppa.legislative_parameters) =
670: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
671: ppa.legislative_parameters))
672: and paa.action_status = 'C'

Line 670: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

666: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
667: and paa.assignment_id = paf.assignment_id
668: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
669: ppa.legislative_parameters) =
670: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
671: ppa.legislative_parameters))
672: and paa.action_status = 'C'
673: and ppa.business_group_id = cp_business_group_id
674: and ppa.payroll_action_id = paa.payroll_action_id

Line 692: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))

688: AND pact.payroll_action_id = passt.payroll_action_id
689: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
690: AND passt.assignment_action_id = pail.locking_action_id
691: AND passt.assignment_id = paa.assignment_id
692: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
693: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
694: AND (pail.locked_action_id = paa.assignment_action_id
695: OR paa.assignment_action_id < passt.assignment_action_id))
696: and ((not exists

Line 693: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

689: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
690: AND passt.assignment_action_id = pail.locking_action_id
691: AND passt.assignment_id = paa.assignment_id
692: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
693: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
694: AND (pail.locked_action_id = paa.assignment_action_id
695: OR paa.assignment_action_id < passt.assignment_action_id))
696: and ((not exists
697: ( SELECT 1

Line 704: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)

700: WHERE ppa2.report_type = 'CAEOY_RL1_AMEND_PP'
701: AND ppa2.payroll_action_id = paa2.payroll_action_id
702: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
703: AND paa2.assignment_action_id > paa.assignment_action_id
704: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
705: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
706: AND paa2.assignment_id=paa.assignment_id
707: ) and lv_ppr_report_type = 'PAYCARL1AMPDF') or lv_ppr_report_type <> 'PAYCARL1AMPDF')
708: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,

Line 705: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

701: AND ppa2.payroll_action_id = paa2.payroll_action_id
702: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
703: AND paa2.assignment_action_id > paa.assignment_action_id
704: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
705: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
706: AND paa2.assignment_id=paa.assignment_id
707: ) and lv_ppr_report_type = 'PAYCARL1AMPDF') or lv_ppr_report_type <> 'PAYCARL1AMPDF')
708: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
709: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

Line 709: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

705: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
706: AND paa2.assignment_id=paa.assignment_id
707: ) and lv_ppr_report_type = 'PAYCARL1AMPDF') or lv_ppr_report_type <> 'PAYCARL1AMPDF')
708: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
709: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
710: ppa.legislative_parameters), --Bug 9133270
711: paf.effective_end_date
712: order by paa.assignment_action_id desc;/*Need to have this to ensure the latest archive assignment_action_id is considered*/
713:

Line 722: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

718: ,cp_business_group_id in number) is
719: select ppa.report_type,
720: paa.assignment_id,
721: paa.assignment_action_id,
722: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
723: ppa.legislative_parameters),
724: paf.effective_end_date
725: from pay_payroll_actions ppa,
726: pay_assignment_actions paa,

Line 731: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

727: per_assignments_f paf,
728: per_periods_of_service pds
729: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
730: and paa.assignment_id = paf.assignment_id
731: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
732: ppa.legislative_parameters) =
733: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
734: ppa.legislative_parameters))
735: and paa.action_status = 'C'

Line 733: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

729: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
730: and paa.assignment_id = paf.assignment_id
731: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
732: ppa.legislative_parameters) =
733: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
734: ppa.legislative_parameters))
735: and paa.action_status = 'C'
736: and ppa.payroll_action_id = paa.payroll_action_id
737: and ppa.effective_date = cp_effective_date

Line 755: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))

751: AND pact.payroll_action_id = passt.payroll_action_id
752: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
753: AND passt.assignment_action_id = pail.locking_action_id
754: AND passt.assignment_id=paf.assignment_id
755: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
756: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
757: AND (pail.locked_action_id = paa.assignment_action_id
758: OR paa.assignment_action_id < passt.assignment_action_id))
759: and pds.actual_termination_date is not null

Line 756: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

752: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
753: AND passt.assignment_action_id = pail.locking_action_id
754: AND passt.assignment_id=paf.assignment_id
755: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
756: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
757: AND (pail.locked_action_id = paa.assignment_action_id
758: OR paa.assignment_action_id < passt.assignment_action_id))
759: and pds.actual_termination_date is not null
760: and pds.period_of_service_id = paf.period_of_service_id

Line 762: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

758: OR paa.assignment_action_id < passt.assignment_action_id))
759: and pds.actual_termination_date is not null
760: and pds.period_of_service_id = paf.period_of_service_id
761: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
762: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
763: ppa.legislative_parameters), --Bug 9133270
764: paf.effective_end_date
765: order by paa.assignment_action_id desc;
766:

Line 775: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

771: ,cp_business_group_id in number) is
772: select ppa.report_type,
773: paa.assignment_id,
774: paa.assignment_action_id,
775: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
776: ppa.legislative_parameters),
777: paf.effective_end_date
778: from pay_payroll_actions ppa,
779: pay_assignment_actions paa,

Line 784: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

780: per_assignments_f paf,
781: per_periods_of_service pds
782: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
783: and paa.assignment_id = paf.assignment_id
784: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
785: ppa.legislative_parameters) =
786: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
787: ppa.legislative_parameters))
788: and paa.action_status = 'C'

Line 786: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

782: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
783: and paa.assignment_id = paf.assignment_id
784: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
785: ppa.legislative_parameters) =
786: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
787: ppa.legislative_parameters))
788: and paa.action_status = 'C'
789: and ppa.business_group_id = cp_business_group_id
790: and ppa.payroll_action_id = paa.payroll_action_id

Line 808: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))

804: AND pact.payroll_action_id = passt.payroll_action_id
805: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
806: AND passt.assignment_action_id = pail.locking_action_id
807: AND passt.assignment_id = paa.assignment_id
808: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
809: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
810: AND (pail.locked_action_id = paa.assignment_action_id
811: OR paa.assignment_action_id < passt.assignment_action_id))
812: and ((not exists

Line 809: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

805: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
806: AND passt.assignment_action_id = pail.locking_action_id
807: AND passt.assignment_id = paa.assignment_id
808: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
809: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
810: AND (pail.locked_action_id = paa.assignment_action_id
811: OR paa.assignment_action_id < passt.assignment_action_id))
812: and ((not exists
813: ( SELECT 1

Line 820: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)

816: WHERE ppa2.report_type = 'CAEOY_RL1_AMEND_PP'
817: AND ppa2.payroll_action_id = paa2.payroll_action_id
818: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
819: AND paa2.assignment_action_id > paa.assignment_action_id
820: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
821: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
822: AND paa2.assignment_id=paa.assignment_id
823: ) and lv_ppr_report_type = 'PAYCARL1AMPDF') or lv_ppr_report_type <> 'PAYCARL1AMPDF')
824: and pds.actual_termination_date is not null

Line 821: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

817: AND ppa2.payroll_action_id = paa2.payroll_action_id
818: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
819: AND paa2.assignment_action_id > paa.assignment_action_id
820: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
821: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
822: AND paa2.assignment_id=paa.assignment_id
823: ) and lv_ppr_report_type = 'PAYCARL1AMPDF') or lv_ppr_report_type <> 'PAYCARL1AMPDF')
824: and pds.actual_termination_date is not null
825: and pds.period_of_service_id = paf.period_of_service_id

Line 827: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

823: ) and lv_ppr_report_type = 'PAYCARL1AMPDF') or lv_ppr_report_type <> 'PAYCARL1AMPDF')
824: and pds.actual_termination_date is not null
825: and pds.period_of_service_id = paf.period_of_service_id
826: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
827: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
828: ppa.legislative_parameters), --Bug 9133270
829: paf.effective_end_date
830: order by paa.assignment_action_id desc;
831: --Changes for bug 15886428 ends2

Line 844: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

840: and report_qualifier = 'CAEOYRL1'
841: and action_type = 'X'
842: and action_status = 'C'
843: and effective_date = cp_year
844: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
845: legislative_parameters)
846: = to_char(cp_pre);
847:
848: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is

Line 1753: end pay_ca_eoy_rl1_amend_reg;

1749: /* hr_utility.trace_on(null,'RL1AMEND_REG'); */
1750: null;
1751:
1752:
1753: end pay_ca_eoy_rl1_amend_reg;