DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on FND_NUMBER

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

5238: from hr_all_positions pos
5239: where pos.position_id = l_pos_id;
5240:
5241: cursor get_org_hrs (l_org_id in NUMBER) is
5242: select fnd_number.canonical_to_number(org.org_information3) normal_hours
5243: , decode(org.org_information4
5244: ,'Y',1
5245: ,'M',12
5246: ,'W',52

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

5250: where org.organization_id(+) = l_org_id
5251: and org.org_information_context(+) = 'Work Day Information';
5252:
5253: cursor get_bus_hrs(l_bg_id in NUMBER) is
5254: select fnd_number.canonical_to_number(bus.working_hours) normal_hours
5255: , decode(bus.frequency
5256: ,'Y',1
5257: ,'M',12
5258: ,'W',52