DBA Data[Home] [Help]

APPS.PAY_DK_PR_LE dependencies on FND_NUMBER

Line 624: ,p_action_information12 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay Value

620: ,p_action_information9 => csr_rec.ele_name -- element name
621: ,p_action_information10 => csr_rec.date_earned -- date_earned
622: ,p_action_information11 => csr_rec.costed_code -- Costed Value
623: /*Storing in Canonical format to fix issues due to varying numeric formats*/
624: ,p_action_information12 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay Value
625: ,p_action_information13 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
626: );
627:
628: END IF ;

Line 625: ,p_action_information13 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD

621: ,p_action_information10 => csr_rec.date_earned -- date_earned
622: ,p_action_information11 => csr_rec.costed_code -- Costed Value
623: /*Storing in Canonical format to fix issues due to varying numeric formats*/
624: ,p_action_information12 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay Value
625: ,p_action_information13 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
626: );
627:
628: END IF ;
629: END LOOP;

Line 667: ,p_action_information12 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay Value

663: ,p_action_information9 => csr_rec.ele_name -- element name
664: ,p_action_information10 => csr_rec.date_earned -- date_earned
665: ,p_action_information11 => csr_rec.costed_code -- Costed Value
666: /*Storing in Canonical format to fix issues due to varying numeric formats*/
667: ,p_action_information12 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay Value
668: ,p_action_information13 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
669: );
670: END IF ;
671: END LOOP;

Line 668: ,p_action_information13 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD

664: ,p_action_information10 => csr_rec.date_earned -- date_earned
665: ,p_action_information11 => csr_rec.costed_code -- Costed Value
666: /*Storing in Canonical format to fix issues due to varying numeric formats*/
667: ,p_action_information12 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay Value
668: ,p_action_information13 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD
669: );
670: END IF ;
671: END LOOP;
672: END IF ;

Line 773: ,fnd_number.canonical_to_number(pai2.action_information12) pay_value

769: ,pai2.action_information8 ele_proc_prior
770: ,pai2.action_information9 ele_name
771: ,pai2.action_information10 date_earned
772: ,pai2.action_information11 costed_code
773: ,fnd_number.canonical_to_number(pai2.action_information12) pay_value
774: ,fnd_number.canonical_to_number(pai2.action_information13) balance_amount
775: FROM
776: pay_action_information pai1
777: ,pay_action_information pai2

Line 774: ,fnd_number.canonical_to_number(pai2.action_information13) balance_amount

770: ,pai2.action_information9 ele_name
771: ,pai2.action_information10 date_earned
772: ,pai2.action_information11 costed_code
773: ,fnd_number.canonical_to_number(pai2.action_information12) pay_value
774: ,fnd_number.canonical_to_number(pai2.action_information13) balance_amount
775: FROM
776: pay_action_information pai1
777: ,pay_action_information pai2
778: WHERE