2992: ,p_us_rate_name varchar2 , p_fr_rate_name varchar2
2993: ,p_us_pay_value_name varchar2 , p_fr_pay_value_name varchar2) is
2994: select class
2995: ,element_type_id Element_type
2996: ,sum(fnd_number.canonical_to_number(base_value)) Base
2997: ,rate_value Rate
2998: ,sum(fnd_number.canonical_to_number(pay_value)) Amount
2999: ,rubric Rubric
3000: ,description Description
2994: select class
2995: ,element_type_id Element_type
2996: ,sum(fnd_number.canonical_to_number(base_value)) Base
2997: ,rate_value Rate
2998: ,sum(fnd_number.canonical_to_number(pay_value)) Amount
2999: ,rubric Rubric
3000: ,description Description
3001: ,sum(source_id) Source_id
3002: ,base_units
3529: --
3530: cursor csr_get_retros is
3531: select
3532: pcu.group_code group_code
3533: , fnd_number.canonical_to_number(result.base_value) base_value
3534: , sum(decode(result.EE_ER
3535: ,'EE',fnd_number.canonical_to_number(result.rate))) ee_rate
3536: , sum(decode(result.EE_ER
3537: ,'EE',fnd_number.canonical_to_number(result.amount))) ee_amount
3531: select
3532: pcu.group_code group_code
3533: , fnd_number.canonical_to_number(result.base_value) base_value
3534: , sum(decode(result.EE_ER
3535: ,'EE',fnd_number.canonical_to_number(result.rate))) ee_rate
3536: , sum(decode(result.EE_ER
3537: ,'EE',fnd_number.canonical_to_number(result.amount))) ee_amount
3538: , sum(decode(result.EE_ER
3539: ,'ER',fnd_number.canonical_to_number(result.rate))) er_rate
3533: , fnd_number.canonical_to_number(result.base_value) base_value
3534: , sum(decode(result.EE_ER
3535: ,'EE',fnd_number.canonical_to_number(result.rate))) ee_rate
3536: , sum(decode(result.EE_ER
3537: ,'EE',fnd_number.canonical_to_number(result.amount))) ee_amount
3538: , sum(decode(result.EE_ER
3539: ,'ER',fnd_number.canonical_to_number(result.rate))) er_rate
3540: , sum(decode(result.EE_ER
3541: ,'ER',fnd_number.canonical_to_number(result.amount))) er_amount
3535: ,'EE',fnd_number.canonical_to_number(result.rate))) ee_rate
3536: , sum(decode(result.EE_ER
3537: ,'EE',fnd_number.canonical_to_number(result.amount))) ee_amount
3538: , sum(decode(result.EE_ER
3539: ,'ER',fnd_number.canonical_to_number(result.rate))) er_rate
3540: , sum(decode(result.EE_ER
3541: ,'ER',fnd_number.canonical_to_number(result.amount))) er_amount
3542: , result.process_type process
3543: , elecls
3537: ,'EE',fnd_number.canonical_to_number(result.amount))) ee_amount
3538: , sum(decode(result.EE_ER
3539: ,'ER',fnd_number.canonical_to_number(result.rate))) er_rate
3540: , sum(decode(result.EE_ER
3541: ,'ER',fnd_number.canonical_to_number(result.amount))) er_amount
3542: , result.process_type process
3543: , elecls
3544: , ptp_start_date
3545: , ptp_end_date
3975: , p_action_information4 => l_rubric
3976: , p_action_information5 => l_description||l_retro_tl
3977: , p_action_information6 => l_append_dates
3978: , p_action_information7 => l_this_process_type
3979: , p_action_information9 => fnd_number.number_to_canonical(
3980: tbl_row_base(l_grouped_rate_ptr))
3981: , p_action_information10 => fnd_number.number_to_canonical(
3982: tbl_ee_rate(l_grouped_rate_ptr))
3983: , p_action_information11 => fnd_number.number_to_canonical(
3977: , p_action_information6 => l_append_dates
3978: , p_action_information7 => l_this_process_type
3979: , p_action_information9 => fnd_number.number_to_canonical(
3980: tbl_row_base(l_grouped_rate_ptr))
3981: , p_action_information10 => fnd_number.number_to_canonical(
3982: tbl_ee_rate(l_grouped_rate_ptr))
3983: , p_action_information11 => fnd_number.number_to_canonical(
3984: tbl_ee_amount(l_grouped_rate_ptr))
3985: , p_action_information12 => fnd_number.number_to_canonical(
3979: , p_action_information9 => fnd_number.number_to_canonical(
3980: tbl_row_base(l_grouped_rate_ptr))
3981: , p_action_information10 => fnd_number.number_to_canonical(
3982: tbl_ee_rate(l_grouped_rate_ptr))
3983: , p_action_information11 => fnd_number.number_to_canonical(
3984: tbl_ee_amount(l_grouped_rate_ptr))
3985: , p_action_information12 => fnd_number.number_to_canonical(
3986: tbl_er_rate(l_grouped_rate_ptr))
3987: , p_action_information13 => fnd_number.number_to_canonical(
3981: , p_action_information10 => fnd_number.number_to_canonical(
3982: tbl_ee_rate(l_grouped_rate_ptr))
3983: , p_action_information11 => fnd_number.number_to_canonical(
3984: tbl_ee_amount(l_grouped_rate_ptr))
3985: , p_action_information12 => fnd_number.number_to_canonical(
3986: tbl_er_rate(l_grouped_rate_ptr))
3987: , p_action_information13 => fnd_number.number_to_canonical(
3988: tbl_er_amount(l_grouped_rate_ptr)));
3989: --
3983: , p_action_information11 => fnd_number.number_to_canonical(
3984: tbl_ee_amount(l_grouped_rate_ptr))
3985: , p_action_information12 => fnd_number.number_to_canonical(
3986: tbl_er_rate(l_grouped_rate_ptr))
3987: , p_action_information13 => fnd_number.number_to_canonical(
3988: tbl_er_amount(l_grouped_rate_ptr)));
3989: --
3990: l_grouped_rate_ptr := tbl_group_code.next(l_grouped_rate_ptr);
3991: end loop grouped_rate_loop;