APPS.HR_PSF_DEL dependencies on HR_ALL_POSITIONS_F

Line 69: delete from hr_all_positions_f

65: --
66: -- Delete the where the effective start date is equal
67: -- to the validation end date.
68: --
69: delete from hr_all_positions_f
70: where position_id = p_rec.position_id
71: and effective_start_date = p_validation_start_date;
72: --
73: Else

Line 81: delete from hr_all_positions_f

77: --
78: -- Delete the row(s) where the effective start date is greater than
79: -- or equal to the validation start date.
80: --
81: delete from hr_all_positions_f
82: where position_id = p_rec.position_id
83: and effective_start_date >= p_validation_start_date;
84: --
85: End If;

Line 378: from hr_all_positions_f

374: select '1'
375: into l_exists
376: from sys.dual
377: where exists(select null
378: from hr_all_positions_f
379: where successor_position_id = p_position_id);
380: exception when no_data_found then
381: null;
382: end;

Line 399: from hr_All_positions_f

395: select '1'
396: into l_exists
397: from sys.dual
398: where exists(select null
399: from hr_All_positions_f
400: where relief_position_id = p_position_id);
401: exception when no_data_found then
402: null;
403: end;

Line 825: from hr_all_positions_f

821: l_validation_end_date date;
822: --
823: cursor c1 is
824: select availability_status_id
825: from hr_all_positions_f
826: where position_id = p_rec.position_id;
827: --
828: Begin
829: g_debug := hr_utility.debug_enabled;