[Home] [Help]
95: is
96: select /*+ ORDERED */
97: pec.classification_name
98: from pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_run_results prr,
101: pay_element_types_f pet,
102: pay_element_classifications pec
103: where paa.assignment_action_id = p_assignment_action_id
206: ppa.business_group_id,
207: ppa.effective_date,
208: ppa.legislative_parameters,
209: pbg.legislation_code
210: from pay_payroll_actions ppa,
211: per_business_groups_perf pbg
212: where ppa.payroll_action_id = p_payroll_action_id
213: and pbg.business_group_id = ppa.business_group_id;
214: --
429: -- consider security view, only employee target (ref ppos)
430: -- include any term emp whose final proc date is before effective date
431: p_sqlstr :=
432: 'select distinct ppos.person_id
433: from pay_payroll_actions ppa,
434: per_people_f pp,
435: per_periods_of_service ppos
436: where ppa.payroll_action_id = :payroll_action_id
437: and pp.business_group_id = ppa.business_group_id + 0
1556: select /*+ ORDERED */
1557: paa.assignment_action_id,
1558: ppa.effective_date
1559: from pay_assignment_actions paa,
1560: pay_payroll_actions ppa
1561: where paa.assignment_id = p_assignment_id
1562: and paa.action_status = 'C'
1563: and ppa.payroll_action_id = paa.payroll_action_id
1564: and ppa.effective_date <= l_effective_date_proc
1569: select /*+ ORDERED */
1570: null
1571: from pay_action_interlocks pai_v,
1572: pay_assignment_actions paa_v,
1573: pay_payroll_actions ppa_v
1574: where pai_v.locked_action_id = paa.assignment_action_id
1575: and paa_v.assignment_action_id = pai_v.locking_action_id
1576: and ppa_v.payroll_action_id = paa.payroll_action_id
1577: and ppa_v.action_type = 'V')