DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on PER_ASSIGNMENTS_F

Line 188: from per_assignments_f

184: -- Define how to retrieve assignment's payroll information
185: --
186: cursor payroll is
187: select payroll_id
188: from per_assignments_f
189: where assignment_id = p_assignment_id
190: and p_effective_date between effective_start_date
191: and effective_end_date;
192: --

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

370: --
371: if (p_entry_type in ('S','D','A','R') or p_processing_type = 'N') then
372: --
373: begin
374: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
375: into adjust_ee_source
376: from pay_legislation_rules plr,
377: per_business_groups pbg,
378: per_assignments_f paf,

Line 378: per_assignments_f paf,

374: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
375: into adjust_ee_source
376: from pay_legislation_rules plr,
377: per_business_groups pbg,
378: per_assignments_f paf,
379: pay_element_entries_f pee
380: where pee.element_entry_id = p_element_entry_id
381: and p_effective_date between pee.effective_start_date
382: and pee.effective_end_date