209: --
210: exists(
211: select null
212: from pay_jp_itax_person_v2 person,
213: pay_jp_itax_arch_v2 arch
214: where person.assignment_id = asg.assignment_id
215: and person.effective_date
216: between g_soy and g_effective_date
217: and ((g_itax_organization_id is null) or (person.itax_organization_id = g_itax_organization_id))
251: and (
252: g_rearchive_flag = 'Y'
253: or not exists(
254: select null
255: from pay_jp_itax_arch_v2 v
256: where v.assignment_id = wic.assignment_id
257: -- effective_date validation is for performance reason.
258: and v.effective_date = wic.effective_date
259: and v.assignment_action_id = wic.assignment_action_id)
431: cp_effective_date date,
432: cp_assignment_action_id number)
433: is
434: select person.action_information_id
435: from pay_jp_itax_arch_v2 arch,
436: pay_jp_itax_person_v2 person
437: where arch.assignment_id = cp_assignment_id
438: -- effective_date validation is for performance reason.
439: and arch.effective_date = cp_effective_date
456: other2.ITW_USER_DESC_KANJI,
457: other2.WTM_USER_DESC_KANJI,
458: other2.WTM_USER_DESC_KANA
459: from pay_jp_itax_person_v2 person,
460: pay_jp_itax_arch_v2 arch,
461: pay_jp_itax_other2_v2 other2
462: where person.assignment_id = cp_assignment_id
463: and person.effective_date
464: between g_soy and g_eoy
484: select person.action_information_id,
485: person.action_context_id,
486: person.effective_date
487: from pay_jp_itax_person_v2 person,
488: pay_jp_itax_arch_v2 arch
489: where person.assignment_id = cp_assignment_id
490: and person.effective_date
491: between g_soy and g_effective_date
492: -- bug.5657929