APPS.PER_SHA_BUS dependencies on PER_STANDARD_HOLIDAYS

Line 225: -- PER_STANDARD_HOLIDAYS

221: -- ----------------------------------------------------------------------------
222: --
223: -- Descriiption :
224: -- STANDARD_HOLIDAY_ID is mandatory and must exist in
225: -- PER_STANDARD_HOLIDAYS
226: --
227: -- Pre-conditions :
228: -- None
229: --

Line 264: FROM per_standard_holidays sth

260: l_api_updating boolean;
261: --
262: CURSOR csr_valid_std_hol_id IS
263: SELECT sth.standard_holiday_id
264: FROM per_standard_holidays sth
265: WHERE sth.standard_holiday_id = p_standard_holiday_id;
266: begin
267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --

Line 277: -- Check that the STANDARD_HOLIDAY_ID exists in PER_STANDARD_HOLIDAYS

273: ,p_argument => 'standard_holiday_id'
274: ,p_argument_value => p_standard_holiday_id
275: );
276: --
277: -- Check that the STANDARD_HOLIDAY_ID exists in PER_STANDARD_HOLIDAYS
278: --
279: open csr_valid_std_hol_id;
280: fetch csr_valid_std_hol_id into l_dummy;
281: if (csr_valid_std_hol_id%NOTFOUND) then

Line 356: FROM per_standard_holidays sth,

352: l_api_updating boolean;
353: --
354: CURSOR csr_valid_actual_date_taken IS
355: SELECT NVL(sth.standard_holiday_id,99)
356: FROM per_standard_holidays sth,
357: per_people_f per,
358: per_business_groups bus
359: WHERE per.person_id = p_person_id
360: AND p_actual_date_taken BETWEEN per.effective_start_date