1241: from per_jobs
1242: where job_id = p_job_id and p_effective_date between date_from and nvl (date_to, p_effective_date);
1243:
1244: cursor csr_get_position (
1245: p_position_id hr_positions_f.position_id%type,
1246: p_effective_date date
1247: ) is
1248: select name
1249: from hr_positions_f
1245: p_position_id hr_positions_f.position_id%type,
1246: p_effective_date date
1247: ) is
1248: select name
1249: from hr_positions_f
1250: where position_id = p_position_id
1251: and p_effective_date between effective_start_date and nvl (effective_end_date, p_effective_date);
1252:
1253: l_balance_name pay_balance_types.balance_name%type;