APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_JP_ITWB_ASSACT_V

Line 3452: from pay_jp_itwb_assact_v pjia,

3448: cursor csr_arch_ass_pay
3449: is
3450: select /*+ ORDERED */
3451: pjia.payroll_id
3452: from pay_jp_itwb_assact_v pjia,
3453: pay_assignment_actions paa_arch_o
3454: where pjia.assignment_id = p_assignment_id
3455: and pjia.effective_date
3456: between g_effective_soy and g_effective_eoy

Line 3586: from pay_jp_itwb_assact_v pjia,

3582: cursor csr_arch_ass_pay
3583: is
3584: select /*+ ORDERED */
3585: pjia.payroll_id
3586: from pay_jp_itwb_assact_v pjia,
3587: pay_assignment_actions paa_arch_o
3588: where pjia.assignment_id = p_assignment_id
3589: and pjia.effective_date
3590: between g_effective_soy and g_effective_eoy

Line 5399: pay_jp_itwb_assact_v pjia

5395: and pjip.status <> 'UPDATE'
5396: and exists(
5397: select null
5398: from pay_assignment_actions paa,
5399: pay_jp_itwb_assact_v pjia
5400: where paa.payroll_action_id = pjip.payroll_action_id
5401: and pjia.assignment_action_id = paa.assignment_action_id)
5402: and not exists(
5403: select /*+ ORDERED */

Line 5422: pay_jp_itwb_assact_v pjia2

5418: and pjip2.archive_sequence > pjip.archive_sequence
5419: and exists(
5420: select null
5421: from pay_assignment_actions paa2,
5422: pay_jp_itwb_assact_v pjia2
5423: where paa2.payroll_action_id = pjip2.payroll_action_id
5424: and pjia2.assignment_action_id = paa2.assignment_action_id));
5425: --
5426: -- use archive_sequence instead of effective_date for case update

Line 6381: pay_jp_itwb_assact_v pjia,

6377: and peev_itax_type2.effective_end_date = pee_itax_type2.effective_end_date
6378: and peev_itax_type2.screen_entry_value <> 'E'
6379: and paa2.assignment_id = paa.assignment_id
6380: and paa2.action_sequence > paa.action_sequence)) larch_v,
6381: pay_jp_itwb_assact_v pjia,
6382: pay_assignment_actions paa_o,
6383: pay_assignment_actions lpaa,
6384: pay_payroll_actions lppa
6385: where pjia.assignment_id (+) = larch_v.assignment_id

Line 6396: from pay_jp_itwb_assact_v pjia2,

6392: between nvl(add_months(trunc(lppa.effective_date,'MM'),1),g_effective_eom) and g_effective_eom
6393: and not exists(
6394: select /*+ ORDERED */
6395: null
6396: from pay_jp_itwb_assact_v pjia2,
6397: pay_assignment_actions paa_o2
6398: where pjia2.assignment_id = larch_v.assignment_id
6399: and pjia2.effective_date
6400: between g_effective_soy and g_effective_som - 1

Line 6560: pay_jp_itwb_assact_v pjia,

6556: and peev_itax_type2.effective_end_date = pee_itax_type2.effective_end_date
6557: and peev_itax_type2.screen_entry_value <> 'E'
6558: and paa2.assignment_id = paa.assignment_id
6559: and paa2.action_sequence > paa.action_sequence)) larch_v,
6560: pay_jp_itwb_assact_v pjia,
6561: pay_assignment_actions paa_o
6562: where pjia.assignment_id (+) = larch_v.assignment_id
6563: and pjia.effective_date (+)
6564: between g_effective_soy and g_effective_eoy

Line 6569: from pay_jp_itwb_assact_v pjia2,

6565: and paa_o.assignment_action_id (+) = pjia.assignment_action_id
6566: and not exists(
6567: select /*+ ORDERED */
6568: null
6569: from pay_jp_itwb_assact_v pjia2,
6570: pay_assignment_actions paa_o2
6571: where pjia2.assignment_id = larch_v.assignment_id
6572: and pjia2.effective_date
6573: between g_effective_soy and g_effective_eoy

Line 6735: pay_jp_itwb_assact_v pjia,

6731: and peev_itax_type2.screen_entry_value <> 'E'
6732: and paa2.assignment_id = paa.assignment_id
6733: and paa2.action_sequence > paa.action_sequence)) larch_v,
6734: hr_assignment_set_amendments hasa,
6735: pay_jp_itwb_assact_v pjia,
6736: pay_assignment_actions paa_o
6737: where to_number(decode(nvl(to_char(g_ass_set_formula_id),'-1'),'-1',
6738: decode(nvl(g_ass_set_amendment_type,'X'),'I',hasa.assignment_id,larch_v.assignment_id),
6739: larch_v.assignment_id)) = larch_v.assignment_id

Line 6750: from pay_jp_itwb_assact_v pjia2,

6746: and paa_o.assignment_action_id (+) = pjia.assignment_action_id
6747: and not exists(
6748: select /*+ ORDERED */
6749: null
6750: from pay_jp_itwb_assact_v pjia2,
6751: pay_assignment_actions paa_o2
6752: where pjia2.assignment_id = larch_v.assignment_id
6753: and pjia2.effective_date
6754: between g_effective_soy and g_effective_eoy

Line 7704: pay_jp_itwb_assact_v pjia,

7700: pjia.assignment_action_id larch_assignment_action_id,
7701: lppa.effective_date lproc_effective_date
7702: from pay_payroll_actions ppa_arch,
7703: pay_assignment_actions paa_arch,
7704: pay_jp_itwb_assact_v pjia,
7705: pay_assignment_actions paa_o,
7706: pay_assignment_actions lpaa,
7707: pay_payroll_actions lppa
7708: where ppa_arch.payroll_action_id = p_payroll_action_id

Line 7719: from pay_jp_itwb_assact_v pjia2,

7715: and lppa.payroll_action_id (+) = lpaa.payroll_action_id
7716: and not exists(
7717: select /*+ ORDERED */
7718: null
7719: from pay_jp_itwb_assact_v pjia2,
7720: pay_assignment_actions paa_o2
7721: where pjia2.assignment_id = pjia.assignment_id
7722: and pjia2.effective_date
7723: between g_effective_soy and g_effective_som - 1

Line 7980: pay_jp_itwb_assact_v pjia,

7976: c_yea_ele_set_id,ppa_proc.date_earned,
7977: c_rey_ele_set_id,ppa_proc.date_earned,ppa_proc.effective_date) lproc_assignment_action_date
7978: from pay_payroll_actions ppa_arch,
7979: pay_assignment_actions paa_arch,
7980: pay_jp_itwb_assact_v pjia,
7981: pay_assignment_actions paa_o,
7982: pay_assignment_actions paa_proc,
7983: pay_payroll_actions ppa_proc
7984: where ppa_arch.payroll_action_id = p_payroll_action_id

Line 7995: from pay_jp_itwb_assact_v pjia2,

7991: and ppa_proc.payroll_action_id (+) = paa_proc.payroll_action_id
7992: and not exists(
7993: select /*+ ORDERED */
7994: null
7995: from pay_jp_itwb_assact_v pjia2,
7996: pay_assignment_actions paa_o2
7997: where pjia2.effective_date
7998: between g_effective_soy and g_effective_eoy
7999: and pjia2.assignment_id = paa_o.assignment_id