DBA Data[Home] [Help]

APPS.PER_DPF_BUS dependencies on HR_POSITIONS_F

Line 206: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req.

202: l_proc varchar2(72) := g_package||'chk_position_id';
203: l_api_updating boolean;
204: l_dummy varchar2(1);
205: --
206: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req.
207: --
208: cursor c1 is
209: select null
210: from hr_positions_f per

Line 210: from hr_positions_f per

206: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req.
207: --
208: cursor c1 is
209: select null
210: from hr_positions_f per
211: where per.position_id = p_position_id
212: and p_effective_date
213: between effective_start_date
214: and effective_end_date

Line 1724: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req.

1720: where per.business_group_id = p_business_group_id
1721: and per.job_id = p_job_id;
1722: --
1723: --
1724: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req.
1725: --
1726: cursor c_positions is
1727: select null
1728: from hr_positions_f per

Line 1728: from hr_positions_f per

1724: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position req.
1725: --
1726: cursor c_positions is
1727: select null
1728: from hr_positions_f per
1729: where per.business_group_id = p_business_group_id
1730: and per.position_id = p_position_id;
1731: --
1732: cursor c_person is