DBA Data[Home] [Help]

APPS.HR_PSF_BUS dependencies on HR_ORGANIZATION_UNITS

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

1539: --
1540: -- Desciption :
1541: --
1542: -- Validate that if the values for WORKING_HOURS and FREQUENCY are null that
1543: -- the values are defaulted from HR_ORGANIZATION_UNITS for the position's
1544: -- ORGANIZATION_ID. When organization defaults are not maintained, the
1545: -- default values from the business group are used.
1546: --
1547: -- Validate that if FREQUENCY is null and WORKING_HOURS is not null

Line 2171: from hr_organization_units oru

2167: and oru.internal_external_flag = 'INT';
2168: --
2169: cursor csr_valid_organization_dates( p_validation_date date) is
2170: select 'x'
2171: from hr_organization_units oru
2172: where oru.organization_id = p_organization_id
2173: and p_validation_date between oru.date_from
2174: and nvl(oru.date_to,hr_api.g_eot);
2175: --

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

2846: --
2847: -- Validate that TIME_NORMAL_FINISH is not before TIME_NORMAL_START.
2848: --
2849: -- Selects TIME_NORMAL_START and TIME_NORMAL_FINISH from the corresponding
2850: -- values on HR_ORGANIZATION_UNITS for the position's ORGANIZATION_ID when
2851: -- the values are null. When organization defaults are not maintained, the
2852: -- default values from the business group are used.
2853: --
2854: -- Pre-conditions: