[Home] [Help]
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
438: and ppos.person_id = pp.person_id
625: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date,
626: null include_or_exclude
627: from per_periods_of_service ppos,
628: per_assignments_f pa,
629: per_people_f pp
630: where ppos.person_id
631: between p_start_person_id and p_end_person_id
632: and ppos.business_group_id + 0 = g_business_group_id
633: and ((nvl(g_inc_term_flag,'N') = 'N'
697: hasa.include_or_exclude
698: from per_periods_of_service ppos,
699: per_assignments_f pa,
700: hr_assignment_set_amendments hasa,
701: per_people_f pp
702: where ppos.person_id
703: between p_start_person_id and p_end_person_id
704: and ppos.business_group_id + 0 = g_business_group_id
705: and ((nvl(g_inc_term_flag,'N') = 'N'