APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_JP_ITWB_PACT_V

Line 5384: pay_jp_itwb_pact_v pjip -- source pact

5380: select /*+ ORDERED */
5381: pjip.payroll_action_id,
5382: pjip.archive_sequence
5383: from pay_payroll_actions ppa, -- proc pact
5384: pay_jp_itwb_pact_v pjip -- source pact
5385: where ppa.business_group_id + 0 = g_business_group_id
5386: and ppa.effective_date
5387: between g_effective_soy and decode(g_arch_option,'ADD',g_effective_som - 1,g_effective_eoy)
5388: and ppa.action_type = 'X'

Line 5406: pay_jp_itwb_pact_v pjip2

5402: and not exists(
5403: select /*+ ORDERED */
5404: null
5405: from pay_payroll_actions ppa2,
5406: pay_jp_itwb_pact_v pjip2
5407: where ppa2.business_group_id + 0 = g_business_group_id
5408: and ppa2.effective_date
5409: between g_effective_soy and decode(g_arch_option,'ADD',g_effective_som - 1,g_effective_eoy)
5410: and ppa2.action_type = 'X'

Line 5434: pay_jp_itwb_pact_v pjip -- source pact

5430: is
5431: select /*+ ORDERED */
5432: pjip.archive_sequence
5433: from pay_payroll_actions ppa, -- proc pact
5434: pay_jp_itwb_pact_v pjip -- source pact
5435: where ppa.business_group_id + 0 = g_business_group_id
5436: and ppa.effective_date
5437: between g_effective_soy and decode(g_arch_option,'ADD',g_effective_som - 1,g_effective_eoy)
5438: and ppa.action_type = 'X'

Line 5450: pay_jp_itwb_pact_v pjip2

5446: and not exists(
5447: select /*+ ORDERED */
5448: null
5449: from pay_payroll_actions ppa2,
5450: pay_jp_itwb_pact_v pjip2
5451: where ppa2.business_group_id + 0 = g_business_group_id
5452: and ppa2.effective_date
5453: between g_effective_soy and decode(g_arch_option,'ADD',g_effective_som - 1,g_effective_eoy)
5454: and ppa2.action_type = 'X'

Line 5764: from pay_jp_itwb_pact_v pjip

5760: -- fetch all historical, future pact in the same year
5761: cursor csr_rollback_pact
5762: is
5763: select pjip.payroll_action_id
5764: from pay_jp_itwb_pact_v pjip
5765: where pjip.itax_org_id = g_itax_organization_id
5766: and pjip.effective_date
5767: between g_effective_soy and g_effective_eoy
5768: order by pjip.archive_sequence desc;

Line 5816: from pay_jp_itwb_pact_v

5812: --
5813: cursor csr_validate_pact
5814: is
5815: select 'Y'
5816: from pay_jp_itwb_pact_v
5817: where payroll_action_id = p_payroll_action_id;
5818: --
5819: cursor csr_org
5820: is