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_ROE_EI_PKG dependencies on PAY_CA_ROE_EI_PKG

Line 1: PACKAGE BODY pay_ca_roe_ei_pkg AS

1: PACKAGE BODY pay_ca_roe_ei_pkg AS
2: /* $Header: pycaroei.pkb 120.12.12020000.4 2012/07/06 09:10:28 vmaripal ship $ */
3:
4: --
5: -- Functions/Procedures

Line 74: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.populate_date_lookup_table';

70: AND asg.effective_end_date
71: AND service.date_start <= p_end_date
72: AND service.date_start >= p_start_date;
73:
74: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.populate_date_lookup_table';
75:
76: l_period_num NUMBER;
77: l_days NUMBER;
78: l_rehire_date DATE;

Line 240: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.taxability_rule_exists';

236: AND trd.taxability_rules_date_id = txr.taxability_rules_date_id
237: AND p_eff_date BETWEEN trd.valid_date_from
238: AND trd.valid_date_to;
239:
240: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.taxability_rule_exists';
241:
242: l_dummy NUMBER;
243:
244: BEGIN

Line 431: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned

427: AND fti.effective_end_date
428: AND fti.assignment_id = asa.assignment_id
429: AND rrs.assignment_action_id = asa.assignment_action_id
430: AND ele.element_type_id = rrs.element_type_id
431: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned
432: (ele.element_type_id,
433: 'DP',
434: ele.element_information3) = 'TRUE'
435: AND pya.effective_date BETWEEN ele.effective_start_date

Line 470: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned

466: AND pya.effective_date BETWEEN p_start_date
467: AND p_end_date
468: AND rrs.assignment_action_id = asa.assignment_action_id
469: AND ele.element_type_id = rrs.element_type_id
470: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned
471: (ele.element_type_id,
472: 'DP',
473: ele.element_information3) = 'TRUE'
474: AND pya.effective_date BETWEEN ele.effective_start_date

Line 515: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned

511: AND pya.date_earned BETWEEN fti.effective_start_date
512: AND fti.effective_end_date
513: AND rrs.assignment_action_id = asa.assignment_action_id
514: AND ele.element_type_id = rrs.element_type_id
515: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned
516: (ele.element_type_id,
517: 'DE',
518: ele.element_information3) = 'TRUE'
519: AND pya.date_earned BETWEEN ele.effective_start_date

Line 554: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned

550: AND pya.date_earned BETWEEN p_start_date
551: AND p_end_date
552: AND rrs.assignment_action_id = asa.assignment_action_id
553: AND ele.element_type_id = rrs.element_type_id
554: AND pay_ca_roe_ei_pkg.date_paid_or_date_earned
555: (ele.element_type_id,
556: 'DE',
557: ele.element_information3) = 'TRUE'
558: AND pya.date_earned BETWEEN ele.effective_start_date

Line 577: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

573: p_gre NUMBER,
574: p_start_date DATE,
575: p_end_date DATE) IS
576: SELECT /*+ RULE */
577: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
578: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
579: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
580: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
581: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 579: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

575: p_end_date DATE) IS
576: SELECT /*+ RULE */
577: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
578: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
579: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
580: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
581: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
582: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
583: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 581: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

577: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
578: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
579: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
580: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
581: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
582: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
583: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
584: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
585: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 583: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

579: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
580: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
581: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
582: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
583: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
584: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
585: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
586: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
587: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 585: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

581: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
582: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
583: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
584: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
585: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
586: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
587: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
588: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
589: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 587: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

583: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
584: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
585: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
586: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
587: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
588: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
589: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
590: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
591: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 589: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

585: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
586: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
587: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
588: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
589: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
590: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
591: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
592: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
593: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 591: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

587: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
588: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
589: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
590: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
591: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
592: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
593: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
594: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
595: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 593: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

589: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
590: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
591: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
592: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
593: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
594: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
595: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
596: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
597: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 595: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

591: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
592: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
593: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
594: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
595: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
596: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
597: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
598: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
599: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 597: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

593: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
594: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
595: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
596: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
597: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
598: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
599: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
600: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
601: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 599: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

595: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
596: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
597: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
598: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
599: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
600: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
601: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
602: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
603: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 601: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

597: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
598: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
599: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
600: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
601: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
602: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
603: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
604: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
605: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 603: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

599: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
600: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
601: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
602: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
603: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
604: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
605: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
606: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
607: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 605: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

601: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
602: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
603: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
604: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
605: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
606: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
607: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
608: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
609: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 607: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

603: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
604: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
605: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
606: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
607: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
608: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
609: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
610: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
611: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 609: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

605: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
606: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
607: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
608: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
609: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
610: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
611: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
612: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
613: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 611: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

607: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
608: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
609: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
610: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
611: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
612: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
613: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
614: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
615: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 613: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

609: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
610: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
611: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
612: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
613: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
614: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
615: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
616: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
617: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 615: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

611: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
612: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
613: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
614: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
615: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
616: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
617: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
618: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
619: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 617: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

613: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
614: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
615: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
616: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
617: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
618: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
619: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
620: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
621: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 619: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

615: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
616: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
617: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
618: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
619: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
620: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
621: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
622: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
623: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 621: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

617: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
618: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
619: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
620: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
621: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
622: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
623: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
624: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
625: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 623: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

619: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
620: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
621: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
622: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
623: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
624: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
625: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
626: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
627: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 625: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

621: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
622: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
623: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
624: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
625: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
626: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
627: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
628: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
629: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 627: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

623: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
624: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
625: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
626: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
627: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
628: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
629: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
630: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
631: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 629: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

625: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
626: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
627: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
628: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
629: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
630: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
631: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
632: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
633: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 631: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

627: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
628: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
629: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
630: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
631: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
632: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
633: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
634: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
635: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 633: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

629: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
630: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
631: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
632: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
633: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
634: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
635: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
636: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
637: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 635: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

631: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
632: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
633: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
634: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
635: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
636: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
637: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
638: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
639: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 637: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

633: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
634: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
635: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
636: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
637: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
638: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
639: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
640: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
641: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 639: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

635: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
636: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
637: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
638: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
639: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
640: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
641: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
642: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
643: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 641: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

637: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
638: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
639: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
640: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
641: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
642: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
643: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
644: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
645: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 643: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

639: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
640: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
641: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
642: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
643: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
644: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
645: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
646: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
647: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 645: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

641: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
642: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
643: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
644: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
645: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
646: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
647: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
648: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
649: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 647: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

643: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
644: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
645: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
646: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
647: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
648: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
649: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
650: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
651: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 649: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

645: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
646: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
647: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
648: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
649: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
650: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
651: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
652: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
653: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 651: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

647: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
648: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
649: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
650: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
651: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
652: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
653: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
654: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
655: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 653: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

649: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
650: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
651: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
652: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
653: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
654: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
655: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
656: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
657: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 655: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

651: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
652: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
653: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
654: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
655: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
656: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
657: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
658: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
659: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 657: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

653: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
654: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
655: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
656: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
657: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
658: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
659: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
660: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
661: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 659: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

655: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
656: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
657: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
658: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
659: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
660: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
661: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
662: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
663: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 661: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

657: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
658: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
659: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
660: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
661: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
662: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
663: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
664: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
665: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 663: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

659: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
660: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
661: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
662: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
663: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
664: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
665: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
666: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
667: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 665: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

661: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
662: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
663: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
664: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
665: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
666: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
667: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
668: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
669: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 667: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

663: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
664: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
665: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
666: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
667: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
668: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
669: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
670: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
671: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 669: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

665: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
666: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
667: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
668: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
669: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
670: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
671: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
672: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
673: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 671: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

667: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
668: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
669: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
670: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
671: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
672: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
673: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
674: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
675: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 673: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

669: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
670: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
671: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
672: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
673: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
674: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
675: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
676: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
677: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 675: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

671: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
672: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
673: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
674: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
675: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
676: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
677: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
678: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
679: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 677: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

673: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
674: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
675: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
676: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
677: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
678: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
679: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
680: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
681: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 679: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

675: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
676: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
677: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
678: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
679: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
680: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
681: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
682: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
683: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 681: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

677: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
678: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
679: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
680: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
681: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
682: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
683: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
684: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
685: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 683: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

679: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
680: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
681: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
682: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
683: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
684: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
685: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
686: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
687: FROM pay_assignment_actions asa,

Line 685: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

681: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
682: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
683: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
684: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
685: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
686: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
687: FROM pay_assignment_actions asa,
688: pay_payroll_actions pya,
689: pay_run_results rrs,

Line 712: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,

708: AND elc.classification_name IN ('Earnings',
709: 'Supplemental Earnings',
710: 'Taxable Benefits',
711: 'Balance Initialization')
712: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,
713: elc.classification_id,
714: ele.element_information1,
715: pya.effective_date,
716: blt.tax_type) = 'TRUE'

Line 737: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

733: p_gre NUMBER,
734: p_start_date DATE,
735: p_end_date DATE) IS
736: SELECT /*+ RULE */
737: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
738: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0),
739: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
740: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
741: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 739: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

735: p_end_date DATE) IS
736: SELECT /*+ RULE */
737: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
738: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0),
739: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
740: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
741: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
742: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
743: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 741: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

737: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
738: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0),
739: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
740: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
741: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
742: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
743: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
744: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
745: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 743: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

739: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
740: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
741: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
742: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
743: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
744: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
745: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
746: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
747: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 745: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

741: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
742: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
743: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
744: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
745: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
746: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
747: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
748: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
749: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 747: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

743: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
744: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
745: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
746: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
747: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
748: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
749: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
750: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
751: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 749: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

745: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
746: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
747: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
748: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
749: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
750: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
751: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
752: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
753: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 751: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

747: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
748: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
749: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
750: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
751: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
752: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
753: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
754: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
755: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 753: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

749: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
750: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
751: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
752: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
753: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
754: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
755: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
756: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
757: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 755: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

751: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
752: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
753: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
754: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
755: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
756: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
757: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
758: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
759: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 757: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

753: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
754: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
755: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
756: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
757: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
758: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
759: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
760: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
761: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 759: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

755: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
756: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
757: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
758: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
759: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
760: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
761: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
762: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
763: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 761: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

757: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
758: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
759: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
760: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
761: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
762: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
763: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
764: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
765: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 763: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

759: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
760: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
761: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
762: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
763: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
764: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
765: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
766: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
767: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 765: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

761: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
762: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
763: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
764: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
765: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
766: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
767: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
768: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
769: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 767: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

763: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
764: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
765: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
766: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
767: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
768: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
769: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
770: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
771: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 769: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

765: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
766: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
767: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
768: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
769: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
770: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
771: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
772: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
773: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 771: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

767: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
768: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
769: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
770: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
771: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
772: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
773: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
774: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
775: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 773: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

769: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
770: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
771: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
772: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
773: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
774: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
775: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
776: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
777: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 775: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

771: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
772: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
773: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
774: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
775: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
776: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
777: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
778: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
779: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 777: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

773: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
774: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
775: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
776: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
777: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
778: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
779: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
780: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
781: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 779: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

775: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
776: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
777: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
778: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
779: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
780: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
781: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
782: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
783: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 781: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

777: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
778: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
779: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
780: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
781: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
782: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
783: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
784: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
785: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 783: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

779: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
780: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
781: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
782: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
783: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
784: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
785: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
786: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
787: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 785: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

781: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
782: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
783: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
784: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
785: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
786: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
787: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
788: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
789: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 787: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

783: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
784: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
785: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
786: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
787: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
788: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
789: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
790: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
791: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 789: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

785: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
786: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
787: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
788: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
789: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
790: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
791: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
792: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
793: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 791: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

787: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
788: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
789: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
790: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
791: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
792: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
793: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
794: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0),
795: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 793: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

789: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
790: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
791: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
792: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
793: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
794: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0),
795: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
796: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
797: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 795: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

791: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
792: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
793: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
794: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0),
795: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
796: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
797: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
798: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
799: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 797: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

793: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
794: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0),
795: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
796: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
797: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
798: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
799: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
800: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
801: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 799: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

795: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
796: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
797: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
798: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
799: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
800: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
801: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
802: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
803: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 801: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

797: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
798: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
799: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
800: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
801: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
802: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
803: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
804: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
805: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 803: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

799: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
800: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
801: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
802: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
803: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
804: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
805: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
806: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
807: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 805: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

801: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
802: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
803: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
804: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
805: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
806: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
807: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
808: 36,NVL(rrv.result_value, 0)*blf.scale,0)),0),
809: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 807: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

803: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
804: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
805: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
806: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
807: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
808: 36,NVL(rrv.result_value, 0)*blf.scale,0)),0),
809: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
810: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
811: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 809: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

805: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
806: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
807: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
808: 36,NVL(rrv.result_value, 0)*blf.scale,0)),0),
809: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
810: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
811: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
812: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
813: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 811: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

807: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
808: 36,NVL(rrv.result_value, 0)*blf.scale,0)),0),
809: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
810: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
811: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
812: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
813: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
814: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
815: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 813: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

809: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
810: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
811: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
812: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
813: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
814: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
815: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
816: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
817: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 815: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

811: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
812: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
813: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
814: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
815: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
816: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
817: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
818: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
819: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 817: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

813: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
814: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
815: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
816: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
817: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
818: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
819: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
820: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
821: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 819: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

815: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
816: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
817: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
818: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
819: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
820: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
821: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
822: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
823: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 821: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

817: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
818: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
819: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
820: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
821: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
822: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
823: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
824: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
825: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 823: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

819: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
820: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
821: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
822: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
823: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
824: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
825: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
826: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
827: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 825: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

821: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
822: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
823: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
824: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
825: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
826: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
827: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
828: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
829: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 827: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

823: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
824: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
825: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
826: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
827: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
828: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
829: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
830: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
831: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 829: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

825: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
826: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
827: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
828: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
829: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
830: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
831: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
832: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
833: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 831: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

827: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
828: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
829: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
830: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
831: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
832: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
833: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
834: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
835: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 833: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

829: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
830: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
831: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
832: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
833: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
834: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
835: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
836: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
837: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 835: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

831: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
832: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
833: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
834: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
835: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
836: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
837: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
838: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
839: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 837: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

833: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
834: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
835: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
836: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
837: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
838: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
839: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
840: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
841: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

Line 839: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

835: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
836: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
837: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
838: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
839: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
840: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
841: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
842: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0)
843: FROM pay_assignment_actions asa,

Line 841: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

837: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
838: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
839: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
840: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
841: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),
842: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0)
843: FROM pay_assignment_actions asa,
844: pay_payroll_actions pya,
845: pay_run_results rrs,

Line 868: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,

864: AND elc.classification_name IN ('Earnings',
865: 'Supplemental Earnings',
866: 'Taxable Benefits',
867: 'Balance Initialization')
868: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,
869: elc.classification_id,
870: ele.element_information1,
871: pya.effective_date,
872: blt.tax_type) = 'TRUE'

Line 893: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

889: p_gre NUMBER,
890: p_start_date DATE,
891: p_end_date DATE) IS
892: SELECT /*+ RULE */
893: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
894: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
895: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
896: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
897: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 895: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

891: p_end_date DATE) IS
892: SELECT /*+ RULE */
893: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
894: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
895: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
896: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
897: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
898: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
899: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 897: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

893: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
894: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
895: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
896: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
897: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
898: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
899: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
900: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
901: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 899: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

895: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
896: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0) +
897: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
898: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
899: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
900: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
901: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
902: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
903: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 901: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

897: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
898: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0),
899: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
900: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
901: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
902: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
903: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
904: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
905: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 903: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

899: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
900: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0),
901: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
902: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
903: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
904: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
905: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
906: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
907: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 905: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

901: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
902: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0),
903: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
904: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
905: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
906: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
907: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
908: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
909: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 907: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

903: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
904: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0),
905: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
906: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
907: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
908: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
909: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
910: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
911: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 909: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

905: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
906: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0),
907: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
908: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
909: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
910: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
911: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
912: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
913: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 911: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

907: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
908: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0),
909: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
910: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
911: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
912: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
913: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
914: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
915: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 913: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

909: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
910: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0),
911: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
912: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
913: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
914: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
915: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
916: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
917: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 915: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

911: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
912: 10,NVL(rrv.result_value, 0)*blf.scale,0)),0),
913: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
914: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
915: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
916: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
917: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
918: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
919: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 917: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

913: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
914: 11,NVL(rrv.result_value, 0)*blf.scale,0)),0),
915: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
916: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
917: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
918: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
919: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
920: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
921: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 919: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

915: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
916: 12,NVL(rrv.result_value, 0)*blf.scale,0)),0),
917: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
918: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
919: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
920: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
921: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
922: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
923: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 921: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

917: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
918: 13,NVL(rrv.result_value, 0)*blf.scale,0)),0),
919: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
920: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
921: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
922: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
923: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
924: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
925: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 923: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

919: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
920: 14,NVL(rrv.result_value, 0)*blf.scale,0)),0),
921: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
922: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
923: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
924: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
925: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
926: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
927: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 925: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

921: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
922: 15,NVL(rrv.result_value, 0)*blf.scale,0)),0),
923: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
924: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
925: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
926: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
927: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
928: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
929: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 927: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

923: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
924: 16,NVL(rrv.result_value, 0)*blf.scale,0)),0),
925: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
926: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
927: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
928: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
929: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
930: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
931: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 929: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

925: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
926: 17,NVL(rrv.result_value, 0)*blf.scale,0)),0),
927: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
928: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
929: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
930: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
931: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
932: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
933: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 931: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

927: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
928: 18,NVL(rrv.result_value, 0)*blf.scale,0)),0),
929: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
930: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
931: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
932: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
933: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
934: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
935: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 933: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

929: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
930: 19,NVL(rrv.result_value, 0)*blf.scale,0)),0),
931: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
932: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
933: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
934: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
935: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
936: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
937: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 935: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

931: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
932: 20,NVL(rrv.result_value, 0)*blf.scale,0)),0),
933: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
934: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
935: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
936: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
937: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
938: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
939: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 937: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

933: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
934: 21,NVL(rrv.result_value, 0)*blf.scale,0)),0),
935: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
936: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
937: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
938: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
939: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
940: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
941: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 939: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

935: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
936: 22,NVL(rrv.result_value, 0)*blf.scale,0)),0),
937: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
938: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
939: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
940: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
941: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
942: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
943: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 941: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

937: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
938: 23,NVL(rrv.result_value, 0)*blf.scale,0)),0),
939: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
940: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
941: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
942: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
943: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
944: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
945: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 943: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

939: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
940: 24,NVL(rrv.result_value, 0)*blf.scale,0)),0),
941: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
942: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
943: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
944: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
945: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
946: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
947: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 945: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

941: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
942: 25,NVL(rrv.result_value, 0)*blf.scale,0)),0),
943: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
944: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
945: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
946: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
947: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
948: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
949: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 947: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

943: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
944: 26,NVL(rrv.result_value, 0)*blf.scale,0)),0),
945: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
946: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
947: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
948: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
949: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
950: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
951: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 949: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

945: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
946: 27,NVL(rrv.result_value, 0)*blf.scale,0)),0),
947: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
948: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
949: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
950: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
951: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
952: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
953: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 951: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

947: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
948: 28,NVL(rrv.result_value, 0)*blf.scale,0)),0),
949: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
950: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
951: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
952: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
953: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
954: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
955: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 953: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

949: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
950: 29,NVL(rrv.result_value, 0)*blf.scale,0)),0),
951: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
952: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
953: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
954: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
955: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
956: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
957: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 955: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

951: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
952: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0),
953: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
954: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
955: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
956: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
957: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
958: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
959: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 957: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

953: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
954: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0),
955: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
956: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
957: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
958: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
959: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
960: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
961: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 959: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

955: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
956: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0),
957: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
958: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
959: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
960: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
961: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
962: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
963: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 961: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

957: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
958: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0),
959: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
960: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
961: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
962: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
963: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
964: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
965: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 963: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

959: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
960: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0),
961: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
962: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
963: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
964: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
965: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
966: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
967: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 965: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

961: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
962: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0),
963: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
964: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
965: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
966: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
967: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
968: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
969: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 967: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

963: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
964: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0),
965: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
966: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
967: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
968: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
969: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
970: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
971: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 969: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

965: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
966: 37,NVL(rrv.result_value, 0)*blf.scale,0)),0),
967: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
968: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
969: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
970: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
971: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
972: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
973: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 971: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

967: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
968: 38,NVL(rrv.result_value, 0)*blf.scale,0)),0),
969: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
970: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
971: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
972: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
973: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
974: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
975: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 973: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

969: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
970: 39,NVL(rrv.result_value, 0)*blf.scale,0)),0),
971: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
972: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
973: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
974: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
975: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
976: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
977: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 975: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

971: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
972: 40,NVL(rrv.result_value, 0)*blf.scale,0)),0),
973: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
974: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
975: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
976: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
977: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
978: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
979: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 977: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

973: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
974: 41,NVL(rrv.result_value, 0)*blf.scale,0)),0),
975: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
976: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
977: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
978: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
979: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
980: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
981: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 979: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

975: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
976: 42,NVL(rrv.result_value, 0)*blf.scale,0)),0),
977: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
978: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
979: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
980: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
981: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
982: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
983: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 981: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

977: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
978: 43,NVL(rrv.result_value, 0)*blf.scale,0)),0),
979: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
980: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
981: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
982: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
983: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
984: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
985: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 983: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

979: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
980: 44,NVL(rrv.result_value, 0)*blf.scale,0)),0),
981: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
982: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
983: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
984: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
985: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
986: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
987: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 985: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

981: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
982: 45,NVL(rrv.result_value, 0)*blf.scale,0)),0),
983: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
984: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
985: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
986: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
987: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
988: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
989: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 987: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

983: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
984: 46,NVL(rrv.result_value, 0)*blf.scale,0)),0),
985: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
986: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
987: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
988: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
989: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
990: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
991: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 989: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

985: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
986: 47,NVL(rrv.result_value, 0)*blf.scale,0)),0),
987: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
988: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
989: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
990: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
991: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
992: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
993: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 991: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

987: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
988: 48,NVL(rrv.result_value, 0)*blf.scale,0)),0),
989: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
990: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
991: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
992: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
993: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
994: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
995: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 993: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

989: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
990: 49,NVL(rrv.result_value, 0)*blf.scale,0)),0),
991: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
992: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
993: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
994: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
995: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
996: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
997: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 995: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

991: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
992: 50,NVL(rrv.result_value, 0)*blf.scale,0)),0),
993: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
994: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
995: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
996: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
997: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
998: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
999: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 997: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

993: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
994: 51,NVL(rrv.result_value, 0)*blf.scale,0)),0),
995: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
996: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
997: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
998: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
999: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1000: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
1001: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 999: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

995: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
996: 52,NVL(rrv.result_value, 0)*blf.scale,0)),0),
997: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
998: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
999: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1000: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
1001: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1002: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
1003: FROM pay_assignment_actions asa,

Line 1001: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

997: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
998: 53,NVL(rrv.result_value, 0)*blf.scale,0)),0),
999: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1000: 54,NVL(rrv.result_value, 0)*blf.scale,0)),0),
1001: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1002: 55,NVL(rrv.result_value, 0)*blf.scale,0)),0)
1003: FROM pay_assignment_actions asa,
1004: pay_payroll_actions pya,
1005: pay_run_results rrs,

Line 1027: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,

1023: AND elc.classification_id = ele.classification_id
1024: AND elc.classification_name IN ('Earnings',
1025: 'Supplemental Earnings',
1026: 'Taxable Benefits')
1027: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,
1028: elc.classification_id,
1029: ele.element_information1,
1030: pya.date_earned,
1031: blt.tax_type) = 'TRUE'

Line 1052: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1048: p_gre NUMBER,
1049: p_start_date DATE,
1050: p_end_date DATE) IS
1051: SELECT /*+ RULE */
1052: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1053: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1054: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1055: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1056: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1054: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1050: p_end_date DATE) IS
1051: SELECT /*+ RULE */
1052: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1053: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1054: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1055: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1056: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1057: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1058: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1056: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1052: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1053: 1, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1054: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1055: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1056: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1057: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1058: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1059: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1060: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1058: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1054: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1055: 2, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1056: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1057: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1058: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1059: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1060: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1061: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1062: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1060: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1056: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1057: 3, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1058: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1059: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1060: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1061: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1062: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1063: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1064: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1062: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1058: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1059: 4, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1060: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1061: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1062: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1063: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1064: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1065: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1066: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1064: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1060: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1061: 5, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1062: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1063: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1064: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1065: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1066: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1067: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1068: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1066: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1062: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1063: 6, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1064: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1065: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1066: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1067: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1068: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1069: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1070: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1068: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1064: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1065: 7, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1066: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1067: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1068: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1069: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1070: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1071: 10, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1072: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1070: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1066: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1067: 8, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1068: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1069: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1070: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1071: 10, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1072: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1073: 11, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1074: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1072: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1068: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1069: 9, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1070: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1071: 10, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1072: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1073: 11, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1074: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1075: 12, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1076: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1074: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1070: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1071: 10, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1072: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1073: 11, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1074: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1075: 12, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1076: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1077: 13, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1078: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1076: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1072: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1073: 11, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1074: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1075: 12, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1076: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1077: 13, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1078: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1079: 14, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1080: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1078: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1074: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1075: 12, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1076: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1077: 13, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1078: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1079: 14, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1080: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1081: 15, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1082: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1080: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1076: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1077: 13, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1078: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1079: 14, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1080: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1081: 15, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1082: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1083: 16, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1084: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1082: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1078: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1079: 14, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1080: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1081: 15, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1082: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1083: 16, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1084: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1085: 17, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1086: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1084: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1080: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1081: 15, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1082: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1083: 16, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1084: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1085: 17, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1086: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1087: 18, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1088: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1086: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1082: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1083: 16, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1084: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1085: 17, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1086: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1087: 18, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1088: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1089: 19, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1090: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1088: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1084: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1085: 17, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1086: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1087: 18, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1088: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1089: 19, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1090: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1091: 20, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1092: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1090: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1086: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1087: 18, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1088: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1089: 19, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1090: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1091: 20, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1092: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1093: 21, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1094: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1092: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1088: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1089: 19, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1090: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1091: 20, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1092: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1093: 21, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1094: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1095: 22, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1096: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1094: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1090: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1091: 20, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1092: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1093: 21, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1094: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1095: 22, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1096: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1097: 23, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1098: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1096: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1092: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1093: 21, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1094: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1095: 22, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1096: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1097: 23, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1098: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1099: 24, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1100: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1098: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1094: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1095: 22, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1096: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1097: 23, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1098: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1099: 24, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1100: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1101: 25, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1102: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1100: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1096: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1097: 23, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1098: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1099: 24, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1100: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1101: 25, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1102: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1103: 26, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1104: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1102: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1098: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1099: 24, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1100: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1101: 25, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1102: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1103: 26, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1104: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1105: 27, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1106: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1104: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1100: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1101: 25, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1102: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1103: 26, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1104: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1105: 27, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1106: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1107: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1108: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1106: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1102: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1103: 26, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1104: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1105: 27, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1106: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1107: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1108: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1109: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1110: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1108: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1104: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1105: 27, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1106: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1107: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1108: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1109: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1110: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1111: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1112: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1110: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1106: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1107: 28, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1108: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1109: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1110: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1111: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1112: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1113: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1114: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1112: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1108: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1109: 29, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1110: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1111: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1112: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1113: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1114: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1115: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1116: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1114: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1110: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1111: 30, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1112: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1113: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1114: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1115: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1116: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1117: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1118: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1116: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1112: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1113: 31, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1114: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1115: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1116: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1117: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1118: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1119: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1120: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1118: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1114: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1115: 32, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1116: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1117: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1118: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1119: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1120: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1121: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1122: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1120: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1116: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1117: 33, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1118: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1119: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1120: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1121: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1122: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1123: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1124: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1122: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1118: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1119: 34, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1120: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1121: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1122: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1123: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1124: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1125: 37, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1126: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1124: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1120: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1121: 35, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1122: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1123: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1124: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1125: 37, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1126: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1127: 38, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1128: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1126: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1122: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1123: 36, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1124: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1125: 37, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1126: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1127: 38, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1128: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1129: 39, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1130: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1128: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1124: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1125: 37, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1126: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1127: 38, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1128: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1129: 39, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1130: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1131: 40, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1132: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1130: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1126: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1127: 38, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1128: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1129: 39, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1130: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1131: 40, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1132: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1133: 41, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1134: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1132: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1128: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1129: 39, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1130: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1131: 40, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1132: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1133: 41, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1134: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1135: 42, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1136: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1134: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1130: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1131: 40, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1132: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1133: 41, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1134: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1135: 42, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1136: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1137: 43, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1138: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1136: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1132: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1133: 41, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1134: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1135: 42, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1136: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1137: 43, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1138: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1139: 44, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1140: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1138: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1134: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1135: 42, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1136: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1137: 43, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1138: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1139: 44, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1140: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1141: 45, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1142: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1140: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1136: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1137: 43, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1138: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1139: 44, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1140: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1141: 45, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1142: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1143: 46, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1144: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1142: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1138: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1139: 44, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1140: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1141: 45, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1142: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1143: 46, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1144: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1145: 47, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1146: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1144: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1140: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1141: 45, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1142: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1143: 46, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1144: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1145: 47, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1146: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1147: 48, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1148: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1146: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1142: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1143: 46, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1144: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1145: 47, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1146: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1147: 48, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1148: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1149: 49, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1150: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1148: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1144: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1145: 47, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1146: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1147: 48, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1148: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1149: 49, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1150: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1151: 50, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1152: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1150: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1146: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1147: 48, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1148: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1149: 49, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1150: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1151: 50, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1152: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1153: 51, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1154: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1152: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1148: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1149: 49, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1150: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1151: 50, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1152: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1153: 51, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1154: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1155: 52, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1156: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

Line 1154: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1150: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1151: 50, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1152: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1153: 51, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1154: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1155: 52, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1156: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1157: 53, NVL(rrv.result_value, 0)*blf.scale,0)),0)
1158: FROM pay_assignment_actions asa,

Line 1156: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),

1152: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1153: 51, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
1154: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1155: 52, NVL(rrv.result_value, 0)*blf.scale,0)),0),
1156: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
1157: 53, NVL(rrv.result_value, 0)*blf.scale,0)),0)
1158: FROM pay_assignment_actions asa,
1159: pay_payroll_actions pya,
1160: pay_run_results rrs,

Line 1182: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,

1178: AND elc.classification_id = ele.classification_id
1179: AND elc.classification_name IN ('Earnings',
1180: 'Supplemental Earnings',
1181: 'Taxable Benefits')
1182: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,
1183: elc.classification_id,
1184: ele.element_information1,
1185: pya.date_earned,
1186: blt.tax_type) = 'TRUE'

Line 1202: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.get_ei_amount_totals';

1198: AND blt.legislation_code = 'CA'
1199: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
1200: SYSDATE, SYSDATE, pya.date_earned, 'EIEXEMPT'),'N') = 'N';
1201:
1202: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.get_ei_amount_totals';
1203:
1204: l_start_date DATE;
1205: l_start_period DATE;
1206: l_last_period_start_date DATE;

Line 2178: period_from := pay_ca_roe_ei_pkg.get_pd_num(i.effective_date,

2174: l_start_period := null;
2175:
2176: end if;
2177:
2178: period_from := pay_ca_roe_ei_pkg.get_pd_num(i.effective_date,
2179: l_last_period_end_date);
2180:
2181: if (l_start_period is not null and
2182: l_value is not null) then

Line 2184: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,

2180:
2181: if (l_start_period is not null and
2182: l_value is not null) then
2183:
2184: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,
2185: l_last_period_end_date);
2186:
2187: hr_utility.trace('period_from = ' || to_char(period_from));
2188: hr_utility.trace('period_to = ' || to_char(period_to));

Line 2386: END pay_ca_roe_ei_pkg;

2382: END IF;
2383:
2384: END date_paid_or_date_earned;
2385:
2386: END pay_ca_roe_ei_pkg;