APPS.PER_PAY_PROPOSALS_POPULATE dependencies on FND_NUMBER

Line 22: SELECT fnd_number.canonical_to_number(PGR.MINIMUM)

18: p_grade_uom OUT NOCOPY VARCHAR2)
19: IS
20:
21: cursor grade_rates IS
22: SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
23: , fnd_number.canonical_to_number(PGR.MAXIMUM)
24: , fnd_number.canonical_to_number(PGR.MID_VALUE)
25: , PRV.RATE_UOM
26: FROM PER_PAY_BASES PPB

Line 23: , fnd_number.canonical_to_number(PGR.MAXIMUM)

19: IS
20:
21: cursor grade_rates IS
22: SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
23: , fnd_number.canonical_to_number(PGR.MAXIMUM)
24: , fnd_number.canonical_to_number(PGR.MID_VALUE)
25: , PRV.RATE_UOM
26: FROM PER_PAY_BASES PPB
27: , PAY_GRADE_RULES_F PGR

Line 24: , fnd_number.canonical_to_number(PGR.MID_VALUE)

20:
21: cursor grade_rates IS
22: SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
23: , fnd_number.canonical_to_number(PGR.MAXIMUM)
24: , fnd_number.canonical_to_number(PGR.MID_VALUE)
25: , PRV.RATE_UOM
26: FROM PER_PAY_BASES PPB
27: , PAY_GRADE_RULES_F PGR
28: , PAY_RATES_V PRV

Line 81: select fnd_number.canonical_to_number(pev.screen_entry_value)

77: p_element_entry_id OUT NOCOPY NUMBER)
78: IS
79:
80: cursor get_element IS
81: select fnd_number.canonical_to_number(pev.screen_entry_value)
82: , pee.element_entry_id
83: from pay_element_entry_values_f pev
84: , pay_element_entries_f pee
85: , per_pay_bases ppb

Line 588: select fnd_number.canonical_to_number(org.org_information3) normal_hours

584: and asg.effective_end_date
585: and asg.position_id=pos.position_id;
586:
587: cursor get_org_hours is
588: select fnd_number.canonical_to_number(org.org_information3) normal_hours
589: , decode(org.org_information4
590: ,'Y',1
591: ,'M',12
592: ,'W',52

Line 604: select fnd_number.canonical_to_number(bus.working_hours) normal_hours

600: and asg.organization_id=org.organization_id(+)
601: and org.org_information_context(+) = 'Work Day Information';
602:
603: cursor get_bus_hours is
604: select fnd_number.canonical_to_number(bus.working_hours) normal_hours
605: , decode(bus.frequency
606: ,'Y',1
607: ,'M',12
608: ,'W',52