APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_JP_ITAX_PERSON_V2

Line 1780: pay_jp_itax_person_v2 pjips

1776: between g_effective_soy and g_effective_eoy
1777: and exists(
1778: select null
1779: from pay_assignment_actions paa,
1780: pay_jp_itax_person_v2 pjips
1781: where paa.payroll_action_id = ppa.payroll_action_id
1782: and pjips.action_context_id = paa.assignment_action_id
1783: and pjips.itax_organization_id = hoi.organization_id)));
1784: --

Line 1895: pay_jp_itax_person_v2 pjip,

1891: from pay_assignment_actions paa_yea,
1892: pay_assignment_actions paa_yea_all,
1893: pay_assignment_actions paa_iarch,
1894: pay_payroll_actions ppa_iarch,
1895: pay_jp_itax_person_v2 pjip,
1896: pay_jp_itax_arch_v2 pjia,
1897: pay_jp_itax_tax_v pjit,
1898: pay_jp_itax_other_v pjio
1899: where paa_yea.assignment_action_id = p_assignment_action_id

Line 1957: pay_jp_itax_person_v2 pjip,

1953: and not exists(
1954: select null
1955: from pay_assignment_actions paa_iarch,
1956: pay_payroll_actions ppa_iarch,
1957: pay_jp_itax_person_v2 pjip,
1958: pay_jp_itax_arch_v2 pjia
1959: where paa_iarch.assignment_id = paa_yea.assignment_id
1960: and ppa_iarch.payroll_action_id = paa_iarch.payroll_action_id
1961: and ppa_iarch.effective_date