DBA Data[Home] [Help]

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 591: select fnd_number.canonical_to_number(org.org_information3) normal_hours

587: and asg.position_id=pos.position_id;
588: --end of code fix for 13071715
589:
590: cursor get_org_hours is
591: select fnd_number.canonical_to_number(org.org_information3) normal_hours
592: , decode(org.org_information4
593: ,'Y',1
594: ,'M',12
595: ,'W',52

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

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