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.10 2007/03/23 05:46:16 pganguly noship $ */
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 576: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.effective_date,p_end_date),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

992: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
993: 51, NVL(rrv.result_value, 0)*blf.scale,0)),0) ,
994: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
995: 52, NVL(rrv.result_value, 0)*blf.scale,0)),0),
996: NVL(SUM(DECODE(pay_ca_roe_ei_pkg.get_pd_num(pya.date_earned,p_end_date),
997: 53, NVL(rrv.result_value, 0)*blf.scale,0)),0)
998: FROM pay_assignment_actions asa,
999: pay_payroll_actions pya,
1000: pay_run_results rrs,

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

1018: AND elc.classification_id = ele.classification_id
1019: AND elc.classification_name IN ('Earnings',
1020: 'Supplemental Earnings',
1021: 'Taxable Benefits')
1022: AND pay_ca_roe_ei_pkg.taxability_rule_exists(elc.classification_name,
1023: elc.classification_id,
1024: ele.element_information1,
1025: pya.date_earned,
1026: blt.tax_type) = 'TRUE'

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

1038: AND blt.legislation_code = 'CA'
1039: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
1040: SYSDATE, SYSDATE, pya.date_earned, 'EIEXEMPT'),'N') = 'N';
1041:
1042: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.get_ei_amount_totals';
1043:
1044: l_start_date DATE;
1045: l_start_period DATE;
1046: l_last_period_start_date DATE;

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

1918: l_start_period := null;
1919:
1920: end if;
1921:
1922: period_from := pay_ca_roe_ei_pkg.get_pd_num(i.effective_date,
1923: l_last_period_end_date);
1924:
1925: if (l_start_period is not null and
1926: l_value is not null) then

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

1924:
1925: if (l_start_period is not null and
1926: l_value is not null) then
1927:
1928: period_to := pay_ca_roe_ei_pkg.get_pd_num(l_start_period,
1929: l_last_period_end_date);
1930:
1931: hr_utility.trace('period_from = ' || to_char(period_from));
1932: hr_utility.trace('period_to = ' || to_char(period_to));

Line 2123: END pay_ca_roe_ei_pkg;

2119: END IF;
2120:
2121: END date_paid_or_date_earned;
2122:
2123: END pay_ca_roe_ei_pkg;