DBA Data[Home] [Help]

APPS.PER_SSM_BUS dependencies on HR_POSITIONS_F

Line 373: -- Changed 13-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req

369: select j.business_group_id, date_from, nvl(date_to,hr_api.g_eot)
370: from per_jobs j
371: where j.job_id = p_parent_id;
372: --
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)

Line 378: from hr_positions_f p

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: --
382: -- Added as part of enhancement 4021737.