APPS.HR_PSF_BUS dependencies on PER_SHARED_TYPES

Line 267: from hr_all_positions_f pos, per_shared_types sht

263: is
264: -- cursor to check active rows for the position prior to the effective_start_date of their row
265: cursor pos_active_rows(p_position_id number,p_effective_start_date date) is
266: select count(*)
267: from hr_all_positions_f pos, per_shared_types sht
268: where pos.position_id = p_position_id
269: and pos.effective_start_date < p_effective_start_date
270: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
271: -- cursor to find out the next active row's effective start date

Line 274: from hr_all_positions_f pos, per_shared_types sht

270: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
271: -- cursor to find out the next active row's effective start date
272: cursor next_active_row(p_position_id number,p_effective_start_date date) is
273: select effective_start_date
274: from hr_all_positions_f pos, per_shared_types sht
275: where pos.position_id = p_position_id
276: and pos.effective_start_date > p_effective_start_date
277: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
278: -- cursor to find the first active row

Line 406: -- Validates that the availability_status_id exists in PER_SHARED_TYPES

402: -- ---------------------------------------------------------------------------
403: --
404: -- Desciption :
405: --
406: -- Validates that the availability_status_id exists in PER_SHARED_TYPES
407: --
408: -- Pre-conditions :
409: --
410: -- In Arguments :

Line 2324: from hr_all_positions_f psf, per_shared_types sht

2320: l_api_updating boolean;
2321: --
2322: cursor csr_valid_successor_position (p_validation_start_date date) is
2323: select 'x'
2324: from hr_all_positions_f psf, per_shared_types sht
2325: where psf.position_id = p_successor_position_id
2326: and psf.availability_status_id = sht.shared_type_id
2327: and (sht.business_group_id = p_business_group_id
2328: or sht.business_group_id is null)

Line 2450: from hr_all_positions_f psf, per_shared_types sht

2446: l_api_updating boolean;
2447: --
2448: cursor csr_valid_relief_position (p_validation_start_date date) is
2449: select 'x'
2450: from hr_all_positions_f psf, per_shared_types sht
2451: where psf.position_id = p_relief_position_id
2452: and psf.availability_status_id = sht.shared_type_id
2453: and (sht.business_group_id = p_business_group_id
2454: or sht.business_group_id is null)

Line 3112: from hr_all_positions_f psf, per_shared_types sht

3108: l_api_updating boolean;
3109: --
3110: cursor csr_valid_supervisor_position (p_validation_start_date date) is
3111: select 'x'
3112: from hr_all_positions_f psf, per_shared_types sht
3113: where psf.position_id = p_supervisor_position_id
3114: and psf.availability_status_id = sht.shared_type_id
3115: and (sht.business_group_id = p_business_group_id
3116: or sht.business_group_id is null)

Line 3238: from hr_all_positions_f psf, per_shared_types sht

3234: l_api_updating boolean;
3235: --
3236: cursor csr_valid_prior_position (p_validation_start_date date) is
3237: select 'x'
3238: from hr_all_positions_f psf, per_shared_types sht
3239: where psf.position_id = p_prior_position_id
3240: and psf.availability_status_id = sht.shared_type_id
3241: and (sht.business_group_id = p_business_group_id
3242: or sht.business_group_id is null)