DBA Data[Home] [Help]

APPS.PAY_DK_PR_ORG dependencies on FND_NUMBER

Line 602: ,p_action_information11 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value

598: ,p_action_information8 => csr_rec.ele_name -- element name
599: ,p_action_information9 => csr_rec.date_earned -- date_earned
600: ,p_action_information10 => csr_rec.costed_code -- Costed value
601: /*Storing in Canonical format to fix issues due to varying numeric formats*/
602: ,p_action_information11 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
603: ,p_action_information12 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
604: );
605: END IF ;
606: END LOOP;

Line 603: ,p_action_information12 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD

599: ,p_action_information9 => csr_rec.date_earned -- date_earned
600: ,p_action_information10 => csr_rec.costed_code -- Costed value
601: /*Storing in Canonical format to fix issues due to varying numeric formats*/
602: ,p_action_information11 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
603: ,p_action_information12 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
604: );
605: END IF ;
606: END LOOP;
607:

Line 643: ,p_action_information11 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value

639: ,p_action_information8 => csr_rec.ele_name -- element name
640: ,p_action_information9 => csr_rec.date_earned -- date_earned
641: ,p_action_information10 => csr_rec.costed_code -- Costed value
642: /*Storing in Canonical format to fix issues due to varying numeric formats*/
643: ,p_action_information11 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
644: ,p_action_information12 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
645: );
646: END IF ;
647: END LOOP;

Line 644: ,p_action_information12 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD

640: ,p_action_information9 => csr_rec.date_earned -- date_earned
641: ,p_action_information10 => csr_rec.costed_code -- Costed value
642: /*Storing in Canonical format to fix issues due to varying numeric formats*/
643: ,p_action_information11 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value
644: ,p_action_information12 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
645: );
646: END IF ;
647: END LOOP;
648: END IF ;

Line 744: ,fnd_number.canonical_to_number(pai2.action_information11) pay_value

740: ,pai2.action_information7 ele_proc_prior
741: ,pai2.action_information8 ele_name
742: ,pai2.action_information9 date_earned
743: ,pai2.action_information10 costed_code
744: ,fnd_number.canonical_to_number(pai2.action_information11) pay_value
745: ,fnd_number.canonical_to_number(pai2.action_information12) balance_amount
746: FROM
747: pay_action_information pai1,pay_action_information pai2
748: WHERE

Line 745: ,fnd_number.canonical_to_number(pai2.action_information12) balance_amount

741: ,pai2.action_information8 ele_name
742: ,pai2.action_information9 date_earned
743: ,pai2.action_information10 costed_code
744: ,fnd_number.canonical_to_number(pai2.action_information11) pay_value
745: ,fnd_number.canonical_to_number(pai2.action_information12) balance_amount
746: FROM
747: pay_action_information pai1,pay_action_information pai2
748: WHERE
749: -- Removing to_char for bug fix 5231458