DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on FND_NUMBER

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

42: from hr_all_positions p
43: where p.position_id = p_position_id ;
44: --
45: cursor get_org_conditions is
46: select fnd_number.canonical_to_number(o.working_hours),
47: o.frequency,
48: o.default_start_time,
49: o.default_end_time
50: from per_all_organization_units o

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

50: from per_all_organization_units o
51: where o.organization_id = p_organization_id ;
52: --
53: cursor get_bg_conditions is
54: select fnd_number.canonical_to_number(b.working_hours),
55: b.frequency,
56: b.default_start_time,
57: b.default_end_time
58: from per_business_groups b

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

1517: --
1518: cursor c5 is
1519: select pbg.name,
1520: pbg.location_id,
1521: fnd_number.canonical_to_number(pbg.working_hours),
1522: pbg.frequency,
1523: pbg.default_start_time,
1524: pbg.default_end_time,
1525: pbg.people_group_structure,