eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_POS_BUS dependencies on HR_ORGANIZATION_UNITS

Line 241: -- HR_ORGANIZATION_UNITS table. (I)

237: --
238: -- Validates that ORGANIZATION_ID is not null
239: --
240: -- Validates that values entered for this column exist in the
241: -- HR_ORGANIZATION_UNITS table. (I)
242: --
243: -- Validates that PER_POSITIONS.DATE_EFFECTIVE cannot be less than the
244: -- DATE_FROM value for the ORGANIZATION record on HR_ORGANIZATION_UNITS.
245: --

Line 244: -- DATE_FROM value for the ORGANIZATION record on HR_ORGANIZATION_UNITS.

240: -- Validates that values entered for this column exist in the
241: -- HR_ORGANIZATION_UNITS table. (I)
242: --
243: -- Validates that PER_POSITIONS.DATE_EFFECTIVE cannot be less than the
244: -- DATE_FROM value for the ORGANIZATION record on HR_ORGANIZATION_UNITS.
245: --
246: -- Pre-conditions:
247: -- Format for p_date_effective must be correct
248: --

Line 255: -- If a row exists in hr_organization_units for the organization id and the

251: -- p_date_effective
252: --
253: -- Post Success :
254: --
255: -- If a row exists in hr_organization_units for the organization id and the
256: -- date conditions are met then processing continues
257: --
258: -- Post Failure :
259: --

Line 260: -- If a row does not exist in hr_organization_units for the organization id

256: -- date conditions are met then processing continues
257: --
258: -- Post Failure :
259: --
260: -- If a row does not exist in hr_organization_units for the organization id
261: -- or the date conditions are not met then an application error will be
262: -- raised and processing is terminated
263: --
264: -- Access Status :

Line 288: from hr_organization_units oru

284: and oru.internal_external_flag = 'INT';
285: --
286: cursor csr_valid_organization_dates is
287: select 'x'
288: from hr_organization_units oru
289: where oru.organization_id = p_organization_id
290: and p_date_effective between oru.date_from
291: and nvl(oru.date_to,hr_api.g_eot);
292: --

Line 534: -- Selects the value for LOCATION_ID from HR_ORGANIZATION_UNITS for the

530: -- ----------------------------------------------------------------------------
531: --
532: -- Desciption :
533: --
534: -- Selects the value for LOCATION_ID from HR_ORGANIZATION_UNITS for the
535: -- position's ORGANIZATION_ID when p_location_id is null. When the
536: -- organization's LOCATION_ID is null the value for the business group is
537: -- selected.
538: --

Line 787: -- the values are defaulted from HR_ORGANIZATION_UNITS for the position's

783: --
784: -- Desciption :
785: --
786: -- Validate that if the values for WORKING_HOURS and FREQUENCY are null that
787: -- the values are defaulted from HR_ORGANIZATION_UNITS for the position's
788: -- ORGANIZATION_ID. When organization defaults are not maintained, the
789: -- default values from the business group are used.
790: --
791: -- Validate that if FREQUENCY is null and WORKING_HOURS is not null

Line 1102: -- values on HR_ORGANIZATION_UNITS for the position's ORGANIZATION_ID when

1098: --
1099: -- Validate that TIME_NORMAL_FINISH is not before TIME_NORMAL_START.
1100: --
1101: -- Selects TIME_NORMAL_START and TIME_NORMAL_FINISH from the corresponding
1102: -- values on HR_ORGANIZATION_UNITS for the position's ORGANIZATION_ID when
1103: -- the values are null. When organization defaults are not maintained, the
1104: -- default values from the business group are used.
1105: --
1106: -- Pre-conditions: