APPS.HR_PFT_DEL dependencies on HR_ALL_POSITIONS_F

Line 62: -- Delete the hr_all_positions_f_tl row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the hr_all_positions_f_tl row.
63: --
64: delete from hr_all_positions_f_tl
65: where position_id = p_rec.position_id
66: and language = p_rec.language;

Line 64: delete from hr_all_positions_f_tl

60: --
61: --
62: -- Delete the hr_all_positions_f_tl row.
63: --
64: delete from hr_all_positions_f_tl
65: where position_id = p_rec.position_id
66: and language = p_rec.language;
67: --
68: --

Line 181: (p_module_name => 'HR_ALL_POSITIONS_F_TL'

177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'HR_ALL_POSITIONS_F_TL'
182: ,p_hook_type => 'AD');
183: --
184: end;
185: --

Line 278: from hr_all_positions_f psf

274: -- Cursor fetches relevant columns from latest datetrack record
275: --
276: cursor c_definition_id IS
277: select psf.position_definition_id
278: from hr_all_positions_f psf
279: where psf.position_id = p_position_id
280: and psf.effective_end_date = hr_api.g_eot;
281: --
282: -- Cursor to obtain all the translation rows.

Line 286: from hr_all_positions_f_tl pft

282: -- Cursor to obtain all the translation rows.
283: --
284: cursor csr_del_langs is
285: select pft.language
286: from hr_all_positions_f_tl pft
287: where pft.position_id = p_position_id;
288: --
289: l_proc varchar2(72) := g_package||'del_tl';
290: --