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 430: pay_jp_itax_person_v2 person

426: cp_effective_date date,
427: cp_assignment_action_id number) is
428: select person.action_information_id
429: from pay_jp_itax_arch_v2 arch,
430: pay_jp_itax_person_v2 person
431: where arch.assignment_id = cp_assignment_id
432: -- effective_date validation is for performance reason.
433: and arch.effective_date = cp_effective_date
434: and arch.assignment_action_id = cp_assignment_action_id

Line 452: from pay_jp_itax_person_v2 person,

448: person.effective_date,
449: other2.ITW_USER_DESC_KANJI,
450: other2.WTM_USER_DESC_KANJI,
451: other2.WTM_USER_DESC_KANA
452: from pay_jp_itax_person_v2 person,
453: pay_jp_itax_arch_v2 arch,
454: pay_jp_itax_other2_v2 other2
455: where person.assignment_id = cp_assignment_id
456: and person.effective_date

Line 479: from pay_jp_itax_person_v2 person,

475: cp_action_information_ids fnd_table_of_number) is
476: select person.action_information_id,
477: person.action_context_id,
478: person.effective_date
479: from pay_jp_itax_person_v2 person,
480: pay_jp_itax_arch_v2 arch
481: where person.assignment_id = cp_assignment_id
482: and person.effective_date
483: between g_soy and g_effective_date

Line 629: from pay_jp_itax_person_v2

625: -- which needs to be changed to (action_context_id) to fix potential bugs.
626: --
627: select count(*)
628: into l_count
629: from pay_jp_itax_person_v2
630: where action_context_id = p_action_context_id
631: and action_information_id <> p_action_information_id;
632: --
633: -- When multiple archives exist, delete the correponding action info only.