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_RL2_AMEND_REG dependencies on PAY_CA_EOY_RL1_AMEND_REG

Line 103: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

99: ,p_report_type out nocopy varchar2
100: )
101: IS
102: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
103: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
104: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
105: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
106: 'PER_ID',ppa.legislative_parameters)),
107: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 105: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

101: IS
102: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
103: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
104: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
105: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
106: 'PER_ID',ppa.legislative_parameters)),
107: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
108: 'ASG_SET_ID',ppa.legislative_parameters)),
109: pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 107: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

103: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
104: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
105: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
106: 'PER_ID',ppa.legislative_parameters)),
107: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
108: 'ASG_SET_ID',ppa.legislative_parameters)),
109: pay_ca_eoy_rl1_amend_reg.get_parameter(
110: 'MODE',ppa.legislative_parameters),
111: effective_date,

Line 109: pay_ca_eoy_rl1_amend_reg.get_parameter(

105: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
106: 'PER_ID',ppa.legislative_parameters)),
107: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
108: 'ASG_SET_ID',ppa.legislative_parameters)),
109: pay_ca_eoy_rl1_amend_reg.get_parameter(
110: 'MODE',ppa.legislative_parameters),
111: effective_date,
112: start_date,
113: business_group_id,

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

436: and cp_end_person
437: and ppa_arch.business_group_id = ln_business_group_id
438: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
439: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
440: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
441: ppa_arch.legislative_parameters) =
442: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
443: ppa_arch.legislative_parameters))
444: and paa_arch.action_status = 'C'

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

438: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
439: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
440: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
441: ppa_arch.legislative_parameters) =
442: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
443: ppa_arch.legislative_parameters))
444: and paa_arch.action_status = 'C'
445: and ppa_arch.effective_date = cp_effective_date
446: and paf.person_id = to_number(paa_arch.serial_number);

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

464: -- and cp_end_person
465: and ppa_arch.business_group_id = ln_business_group_id
466: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
467: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
468: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
469: ppa_arch.legislative_parameters) =
470: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
471: ppa_arch.legislative_parameters))
472: and paa_arch.action_status = 'C'

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

466: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
467: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
468: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
469: ppa_arch.legislative_parameters) =
470: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
471: ppa_arch.legislative_parameters))
472: and paa_arch.action_status = 'C'
473: and ppa_arch.effective_date = cp_effective_date
474: and paf.person_id = to_number(paa_arch.serial_number)

Line 560: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

556: ,cp_business_group_id in number) is
557: select ppa.report_type,
558: paa.assignment_id,
559: paa.assignment_action_id,
560: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
561: ppa.legislative_parameters),
562: paf.effective_end_date
563: from pay_payroll_actions ppa,
564: pay_assignment_actions paa,

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

564: pay_assignment_actions paa,
565: per_assignments_f paf
566: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
567: and paa.assignment_id = paf.assignment_id
568: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
569: ppa.legislative_parameters) =
570: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
571: ppa.legislative_parameters))
572: and paa.action_status = 'C'

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

566: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
567: and paa.assignment_id = paf.assignment_id
568: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
569: ppa.legislative_parameters) =
570: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
571: ppa.legislative_parameters))
572: and paa.action_status = 'C'
573: and ppa.payroll_action_id = paa.payroll_action_id
574: and ppa.effective_date = cp_effective_date

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

588: AND pact.payroll_action_id = passt.payroll_action_id
589: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
590: AND passt.assignment_action_id = pail.locking_action_id
591: AND passt.assignment_id=paf.assignment_id
592: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
593: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
594: AND (pail.locked_action_id = paa.assignment_action_id
595: OR paa.assignment_action_id < passt.assignment_action_id))
596: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,

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

589: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
590: AND passt.assignment_action_id = pail.locking_action_id
591: AND passt.assignment_id=paf.assignment_id
592: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
593: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
594: AND (pail.locked_action_id = paa.assignment_action_id
595: OR paa.assignment_action_id < passt.assignment_action_id))
596: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
597: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

Line 597: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

593: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
594: AND (pail.locked_action_id = paa.assignment_action_id
595: OR paa.assignment_action_id < passt.assignment_action_id))
596: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
597: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
598: ppa.legislative_parameters), --Bug 9133270
599: paf.effective_end_date
600: order by paa.assignment_action_id desc;
601:

Line 609: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

605: ,cp_business_group_id in number) is
606: select ppa.report_type,
607: paa.assignment_id,
608: paa.assignment_action_id,
609: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
610: ppa.legislative_parameters)
611: from pay_payroll_actions ppa,
612: pay_assignment_actions paa
613: where paa.serial_number = to_char(cp_person_id)

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

610: ppa.legislative_parameters)
611: from pay_payroll_actions ppa,
612: pay_assignment_actions paa
613: where paa.serial_number = to_char(cp_person_id)
614: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
615: ppa.legislative_parameters) =
616: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
617: ppa.legislative_parameters))
618: and paa.action_status = 'C'

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

612: pay_assignment_actions paa
613: where paa.serial_number = to_char(cp_person_id)
614: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
615: ppa.legislative_parameters) =
616: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
617: ppa.legislative_parameters))
618: and paa.action_status = 'C'
619: and ppa.business_group_id = cp_business_group_id
620: and ppa.payroll_action_id = paa.payroll_action_id

Line 629: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

625: where paf.assignment_id = paa.assignment_id
626: and paf.effective_start_date <= cp_effective_date
627: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
628: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
629: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
630: ppa.legislative_parameters) --Bug 9133270
631: order by paa.assignment_action_id desc;
632:
633: CURSOR get_reprint_rl2_amend_dtls (cp_person_id in number

Line 640: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

636: ,cp_business_group_id in number) is
637: select ppa.report_type,
638: paa.assignment_id,
639: paa.assignment_action_id,
640: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
641: ppa.legislative_parameters),
642: paf.effective_end_date
643: from pay_payroll_actions ppa,
644: pay_assignment_actions paa,

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

644: pay_assignment_actions paa,
645: per_assignments_f paf
646: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
647: and paa.assignment_id = paf.assignment_id
648: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
649: ppa.legislative_parameters) =
650: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
651: ppa.legislative_parameters))
652: and paa.action_status = 'C'

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

646: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
647: and paa.assignment_id = paf.assignment_id
648: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
649: ppa.legislative_parameters) =
650: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
651: ppa.legislative_parameters))
652: and paa.action_status = 'C'
653: and ppa.business_group_id = cp_business_group_id
654: and ppa.payroll_action_id = paa.payroll_action_id

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

668: AND pact.payroll_action_id = passt.payroll_action_id
669: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
670: AND passt.assignment_action_id = pail.locking_action_id
671: AND passt.assignment_id = paa.assignment_id
672: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
673: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
674: AND (pail.locked_action_id = paa.assignment_action_id
675: OR paa.assignment_action_id < passt.assignment_action_id))
676: and ((not exists

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

669: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
670: AND passt.assignment_action_id = pail.locking_action_id
671: AND passt.assignment_id = paa.assignment_id
672: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
673: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
674: AND (pail.locked_action_id = paa.assignment_action_id
675: OR paa.assignment_action_id < passt.assignment_action_id))
676: and ((not exists
677: ( SELECT 1

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

679: pay_assignment_actions paa2
680: WHERE ppa2.report_type = 'CAEOY_RL2_AMEND_PP'
681: AND ppa2.payroll_action_id = paa2.payroll_action_id
682: AND paa2.assignment_action_id > paa.assignment_action_id
683: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
684: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
685: AND paa2.assignment_id=paa.assignment_id
686: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
687: ) and lv_ppr_report_type = 'PAYCARL2AMPDF') or lv_ppr_report_type <> 'PAYCARL2AMPDF')

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

680: WHERE ppa2.report_type = 'CAEOY_RL2_AMEND_PP'
681: AND ppa2.payroll_action_id = paa2.payroll_action_id
682: AND paa2.assignment_action_id > paa.assignment_action_id
683: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
684: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
685: AND paa2.assignment_id=paa.assignment_id
686: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
687: ) and lv_ppr_report_type = 'PAYCARL2AMPDF') or lv_ppr_report_type <> 'PAYCARL2AMPDF')
688: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,

Line 689: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

685: AND paa2.assignment_id=paa.assignment_id
686: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
687: ) and lv_ppr_report_type = 'PAYCARL2AMPDF') or lv_ppr_report_type <> 'PAYCARL2AMPDF')
688: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
689: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
690: ppa.legislative_parameters), --Bug 9133270
691: paf.effective_end_date
692: order by paa.assignment_action_id desc;
693:

Line 703: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

699: ,cp_business_group_id in number) is
700: select ppa.report_type,
701: paa.assignment_id,
702: paa.assignment_action_id,
703: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
704: ppa.legislative_parameters),
705: paf.effective_end_date
706: from pay_payroll_actions ppa,
707: pay_assignment_actions paa,

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

708: per_assignments_f paf,
709: per_periods_of_service pds
710: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
711: and paa.assignment_id = paf.assignment_id
712: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
713: ppa.legislative_parameters) =
714: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
715: ppa.legislative_parameters))
716: and paa.action_status = 'C'

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

710: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
711: and paa.assignment_id = paf.assignment_id
712: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
713: ppa.legislative_parameters) =
714: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
715: ppa.legislative_parameters))
716: and paa.action_status = 'C'
717: and ppa.payroll_action_id = paa.payroll_action_id
718: and ppa.effective_date = cp_effective_date

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

732: AND pact.payroll_action_id = passt.payroll_action_id
733: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
734: AND passt.assignment_action_id = pail.locking_action_id
735: AND passt.assignment_id=paf.assignment_id
736: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
737: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
738: AND (pail.locked_action_id = paa.assignment_action_id
739: OR paa.assignment_action_id < passt.assignment_action_id))
740: and pds.actual_termination_date is not null

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

733: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
734: AND passt.assignment_action_id = pail.locking_action_id
735: AND passt.assignment_id=paf.assignment_id
736: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
737: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
738: AND (pail.locked_action_id = paa.assignment_action_id
739: OR paa.assignment_action_id < passt.assignment_action_id))
740: and pds.actual_termination_date is not null
741: and pds.period_of_service_id = paf.period_of_service_id

Line 743: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

739: OR paa.assignment_action_id < passt.assignment_action_id))
740: and pds.actual_termination_date is not null
741: and pds.period_of_service_id = paf.period_of_service_id
742: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
743: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
744: ppa.legislative_parameters), --Bug 9133270
745: paf.effective_end_date
746: order by paa.assignment_action_id desc;
747:

Line 755: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

751: ,cp_business_group_id in number) is
752: select ppa.report_type,
753: paa.assignment_id,
754: paa.assignment_action_id,
755: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
756: ppa.legislative_parameters),
757: paf.effective_end_date
758: from pay_payroll_actions ppa,
759: pay_assignment_actions paa,

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

760: per_assignments_f paf,
761: per_periods_of_service pds
762: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
763: and paa.assignment_id = paf.assignment_id
764: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
765: ppa.legislative_parameters) =
766: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
767: ppa.legislative_parameters))
768: and paa.action_status = 'C'

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

762: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
763: and paa.assignment_id = paf.assignment_id
764: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
765: ppa.legislative_parameters) =
766: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
767: ppa.legislative_parameters))
768: and paa.action_status = 'C'
769: and ppa.business_group_id = cp_business_group_id
770: and ppa.payroll_action_id = paa.payroll_action_id

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

784: AND pact.payroll_action_id = passt.payroll_action_id
785: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
786: AND passt.assignment_action_id = pail.locking_action_id
787: AND passt.assignment_id = paa.assignment_id
788: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
789: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
790: AND (pail.locked_action_id = paa.assignment_action_id
791: OR paa.assignment_action_id < passt.assignment_action_id))
792: and ((not exists

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

785: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
786: AND passt.assignment_action_id = pail.locking_action_id
787: AND passt.assignment_id = paa.assignment_id
788: AND nvl(passt.tax_unit_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',pact.legislative_parameters))
789: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
790: AND (pail.locked_action_id = paa.assignment_action_id
791: OR paa.assignment_action_id < passt.assignment_action_id))
792: and ((not exists
793: ( SELECT 1

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

795: pay_assignment_actions paa2
796: WHERE ppa2.report_type = 'CAEOY_RL2_AMEND_PP'
797: AND ppa2.payroll_action_id = paa2.payroll_action_id
798: AND paa2.assignment_action_id > paa.assignment_action_id
799: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
800: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
801: AND paa2.assignment_id=paa.assignment_id
802: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
803: ) and lv_ppr_report_type = 'PAYCARL2AMPDF') or lv_ppr_report_type <> 'PAYCARL2AMPDF')

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

796: WHERE ppa2.report_type = 'CAEOY_RL2_AMEND_PP'
797: AND ppa2.payroll_action_id = paa2.payroll_action_id
798: AND paa2.assignment_action_id > paa.assignment_action_id
799: AND pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa2.legislative_parameters)
800: = pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
801: AND paa2.assignment_id=paa.assignment_id
802: AND ppa2.effective_date = cp_effective_date /*Added for 10381064*/
803: ) and lv_ppr_report_type = 'PAYCARL2AMPDF') or lv_ppr_report_type <> 'PAYCARL2AMPDF')
804: and pds.actual_termination_date is not null

Line 807: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

803: ) and lv_ppr_report_type = 'PAYCARL2AMPDF') or lv_ppr_report_type <> 'PAYCARL2AMPDF')
804: and pds.actual_termination_date is not null
805: and pds.period_of_service_id = paf.period_of_service_id
806: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,
807: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
808: ppa.legislative_parameters), --Bug 9133270
809: paf.effective_end_date
810: order by paa.assignment_action_id desc;
811: --Changes for bug 15886428 ends

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

821: and report_qualifier = 'CAEOYRL2'
822: and action_type = 'X'
823: and action_status = 'C'
824: and effective_date = cp_year
825: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
826: legislative_parameters) = to_char(cp_pre);
827:
828: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
829: select substr(full_name,1,48), employee_number