APPS.HRENTMNT dependencies on PER_ASSIGNMENTS_F

Line 2304: from per_assignments_f

2300: /*Bug 9295968 Begin */
2301: begin
2302: select 1
2303: into sp_exists
2304: from per_assignments_f
2305: where assignment_id = p_assignment_id
2306: and pay_basis_id is not null
2307: and p_validation_start_date between effective_start_date and effective_end_date;
2308:

Line 4128: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode

4124: if g_debug then
4125: hr_utility.set_location(l_proc, 20);
4126: end if;
4127: --
4128: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
4129: into l_adjust_ee_source
4130: from pay_legislation_rules plr,
4131: per_business_groups_perf pbg,
4132: per_all_assignments_f paf

Line 5974: from per_assignments_f asg,

5970: p_assignment_id number,
5971: p_final_process_date date
5972: ) is
5973: select ptp.start_date
5974: from per_assignments_f asg,
5975: per_time_periods ptp
5976: where asg.assignment_id = p_assignment_id
5977: and p_final_process_date
5978: between effective_start_date and asg.effective_end_date

Line 6904: from per_assignments_f

6900: --
6901: cursor csr_sec_asg(p_asgid number)
6902: is
6903: select 1
6904: from per_assignments_f
6905: where assignment_id = p_asgid;
6906:
6907: --
6908: -- local variables