DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on FND_NUMBER

Line 42: select fnd_number.canonical_to_number(o.working_hours),

38: from hr_all_positions p
39: where p.position_id = p_position_id ;
40: --
41: cursor get_org_conditions is
42: select fnd_number.canonical_to_number(o.working_hours),
43: o.frequency,
44: o.default_start_time,
45: o.default_end_time
46: from per_all_organization_units o

Line 50: select fnd_number.canonical_to_number(b.working_hours),

46: from per_all_organization_units o
47: where o.organization_id = p_organization_id ;
48: --
49: cursor get_bg_conditions is
50: select fnd_number.canonical_to_number(b.working_hours),
51: b.frequency,
52: b.default_start_time,
53: b.default_end_time
54: from per_business_groups b

Line 1397: fnd_number.canonical_to_number(pbg.working_hours),

1393: --
1394: cursor c5 is
1395: select pbg.name,
1396: pbg.location_id,
1397: fnd_number.canonical_to_number(pbg.working_hours),
1398: pbg.frequency,
1399: pbg.default_start_time,
1400: pbg.default_end_time,
1401: pbg.people_group_structure,