DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on FND_NUMBER

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

5379: from hr_all_positions pos
5380: where pos.position_id = l_pos_id;
5381:
5382: cursor get_org_hrs (l_org_id in NUMBER) is
5383: select fnd_number.canonical_to_number(org.org_information3) normal_hours
5384: , decode(org.org_information4
5385: ,'Y',1
5386: ,'M',12
5387: ,'W',52

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

5391: where org.organization_id(+) = l_org_id
5392: and org.org_information_context(+) = 'Work Day Information';
5393:
5394: cursor get_bus_hrs(l_bg_id in NUMBER) is
5395: select fnd_number.canonical_to_number(bus.working_hours) normal_hours
5396: , decode(bus.frequency
5397: ,'Y',1
5398: ,'M',12
5399: ,'W',52