APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PAY_JP_ITAX_ARCH_V2

Line 213: pay_jp_itax_arch_v2 arch

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))

Line 255: from pay_jp_itax_arch_v2 v

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)

Line 429: from pay_jp_itax_arch_v2 arch,

425: cp_assignment_id number,
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

Line 453: pay_jp_itax_arch_v2 arch,

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
457: between g_soy and g_eoy

Line 480: pay_jp_itax_arch_v2 arch

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
484: -- bug.5657929