APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PAY_JP_ITAX_PERSON_V2

Line 212: from pay_jp_itax_person_v2 person,

208: -- then latter "exists" is not checked.
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

Line 436: pay_jp_itax_person_v2 person

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
440: and arch.assignment_action_id = cp_assignment_action_id

Line 459: from pay_jp_itax_person_v2 person,

455: person.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

Line 487: from pay_jp_itax_person_v2 person,

483: is
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

Line 640: from pay_jp_itax_person_v2

636: -- which needs to be changed to (action_context_id) to fix potential bugs.
637: --
638: select count(*)
639: into l_count
640: from pay_jp_itax_person_v2
641: where action_context_id = p_action_context_id
642: and action_information_id <> p_action_information_id;
643: --
644: -- When multiple archives exist, delete the correponding action info only.