DBA Data[Home] [Help]

APPS.PAY_DK_PR_ELE dependencies on FND_NUMBER

Line 572: ,p_action_information9 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value

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;

Line 573: ,p_action_information10 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD

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:

Line 610: ,p_action_information9 => fnd_number.number_to_canonical(csr_rec.pay_value) -- Pay value

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;

Line 611: ,p_action_information10 => fnd_number.number_to_canonical(l_ele_ytd) -- element YTD

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 ;

Line 709: ,fnd_number.canonical_to_number(pai2.action_information9) pay_value

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,

Line 710: ,fnd_number.canonical_to_number(pai2.action_information10) balance_amount

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