APPS.PAY_PAYWSMEE_PKG dependencies on PER_ASSIGNMENTS_F

Line 171: from per_assignments_f

167: -- Define how to retrieve assignment's payroll information
168: --
169: cursor payroll is
170: select payroll_id
171: from per_assignments_f
172: where assignment_id = p_assignment_id
173: and p_effective_date between effective_start_date
174: and effective_end_date;
175: --

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

351: --
352: if (p_entry_type in ('S','D','A','R') or p_processing_type = 'N') then
353: --
354: begin
355: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
356: into adjust_ee_source
357: from pay_legislation_rules plr,
358: per_business_groups pbg,
359: per_assignments_f paf,

Line 359: per_assignments_f paf,

355: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
356: into adjust_ee_source
357: from pay_legislation_rules plr,
358: per_business_groups pbg,
359: per_assignments_f paf,
360: pay_element_entries_f pee
361: where pee.element_entry_id = p_element_entry_id
362: and p_effective_date between pee.effective_start_date
363: and pee.effective_end_date