568: ,p_action_information6 => csr_rec.ele_name -- element name
569: ,p_action_information7 => csr_rec.date_earned -- date_earned
570: ,p_action_information8 => csr_rec.costed_code -- Costed value
571: /*Storing in Canonical format to fix issues due to varying numeric formats*/
572: ,p_action_information9 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
573: ,p_action_information10 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
574: );
575: END IF;
576: END LOOP;
569: ,p_action_information7 => csr_rec.date_earned -- date_earned
570: ,p_action_information8 => csr_rec.costed_code -- Costed value
571: /*Storing in Canonical format to fix issues due to varying numeric formats*/
572: ,p_action_information9 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
573: ,p_action_information10 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
574: );
575: END IF;
576: END LOOP;
577:
606: ,p_action_information6 => csr_rec.ele_name -- element name
607: ,p_action_information7 => csr_rec.date_earned -- date_earned
608: ,p_action_information8 => csr_rec.costed_code -- Costed value
609: /*Storing in Canonical format to fix issues due to varying numeric formats*/
610: ,p_action_information9 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
611: ,p_action_information10 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
612: );
613: END IF ;
614: END LOOP;
607: ,p_action_information7 => csr_rec.date_earned -- date_earned
608: ,p_action_information8 => csr_rec.costed_code -- Costed value
609: /*Storing in Canonical format to fix issues due to varying numeric formats*/
610: ,p_action_information9 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
611: ,p_action_information10 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
612: );
613: END IF ;
614: END LOOP;
615: END IF ;
705: ,pai2.action_information5 ele_proc_prior
706: ,pai2.action_information6 ele_name
707: ,pai2.action_information7 date_earned
708: ,pai2.action_information8 costed_code
709: ,fnd_number.canonical_to_number(pai2.action_information9) pay_value
710: ,fnd_number.canonical_to_number(pai2.action_information10) balance_amount
711:
712: FROM
713: pay_action_information pai1,
706: ,pai2.action_information6 ele_name
707: ,pai2.action_information7 date_earned
708: ,pai2.action_information8 costed_code
709: ,fnd_number.canonical_to_number(pai2.action_information9) pay_value
710: ,fnd_number.canonical_to_number(pai2.action_information10) balance_amount
711:
712: FROM
713: pay_action_information pai1,
714: pay_action_information pai2