[Home] [Help]
448: from per_all_assignments_f paa
449: where paa.assignment_id=c_assignment_id
450: and not exists
451: (select 1
452: from per_all_assignments_f paaf, pay_all_payrolls_f papf, hr_soft_coding_keyflex scl
453: where paaf.person_id=paa.person_id
454: and paaf.effective_start_date < paa.effective_start_date
455: and paaf.effective_end_date > g_end_date
456: and paaf.organization_id=paa.organization_id
486: -- Query to fetch assignment_id.
487: /*l_select_str := 'select distinct paaf.assignment_id, ppf.person_id from
488: per_all_assignments_f paaf,
489: per_all_people_f ppf,
490: pay_all_payrolls_f papf,
491: pay_payroll_actions ppa,
492: hr_soft_coding_keyflex scl
493: where paaf.business_group_id = '|| g_business_group_id
494: ||' and paaf.effective_start_date between '||''''||g_start_date||''''||' and '
508: l_select_str := 'select distinct paaf.assignment_id asgid, ppf.person_id perid, pps.period_of_service_id, paaf.assignment_number
509: from
510: per_all_assignments_f paaf,
511: per_all_people_f ppf,
512: pay_all_payrolls_f papf,
513: pay_payroll_actions ppa,
514: hr_soft_coding_keyflex scl,
515: per_periods_of_service pps
516: where paaf.business_group_id = '|| g_business_group_id
834: -- Bug# 7005067
835: FROM per_all_people_f ppf,
836: per_addresses pa,
837: per_all_assignments_f paa,
838: pay_all_payrolls_f pap,
839: pay_assignment_actions ppaa,
840: pa_country_v pc, -- Bug# 7005067
841: fnd_lookup_values flv -- Bug# 7005067
842: WHERE ppaa.assignment_action_id=passactid