APPS.PER_SSM_BUS dependencies on HR_GENERAL

Line 377: nvl(hr_general.get_position_date_end(p.position_id),hr_general.end_of_time)

373: -- Changed 13-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req
374: --
375: cursor csr_chk_position_id_exists is
376: select p.business_group_id,date_effective,
377: nvl(hr_general.get_position_date_end(p.position_id),hr_general.end_of_time)
378: from hr_positions_f p
379: where p.position_id = p_parent_id
380: and effective_end_date = hr_general.end_of_time;
381: --

Line 380: and effective_end_date = hr_general.end_of_time;

376: select p.business_group_id,date_effective,
377: nvl(hr_general.get_position_date_end(p.position_id),hr_general.end_of_time)
378: from hr_positions_f p
379: where p.position_id = p_parent_id
380: and effective_end_date = hr_general.end_of_time;
381: --
382: -- Added as part of enhancement 4021737.
383: cursor csr_chk_assignment_id_exists is
384: select p.business_group_id,effective_start_date,

Line 388: and effective_end_date = hr_general.end_of_time;

384: select p.business_group_id,effective_start_date,
385: effective_end_date
386: from per_all_assignments_f p
387: where p.assignment_id = p_parent_id
388: and effective_end_date = hr_general.end_of_time;
389: --
390: Begin
391: --
392: hr_utility.set_location('Entering:'||l_proc,5);