APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 6099: pay_element_entry_values_f peev_itax_org,

6095: pay_link_input_values_f pliv_itax_org,
6096: pay_link_input_values_f pliv_itax_type,
6097: pay_element_entries_f pee_itax_org,
6098: pay_element_entries_f pee_itax_type,
6099: pay_element_entry_values_f peev_itax_org,
6100: pay_element_entry_values_f peev_itax_type
6101: where ppa.business_group_id + 0 = g_business_group_id
6102: and ppa.action_status = 'C'
6103: and ppa.action_type in ('R', 'Q', 'B', 'I')

Line 6100: pay_element_entry_values_f peev_itax_type

6096: pay_link_input_values_f pliv_itax_type,
6097: pay_element_entries_f pee_itax_org,
6098: pay_element_entries_f pee_itax_type,
6099: pay_element_entry_values_f peev_itax_org,
6100: pay_element_entry_values_f peev_itax_type
6101: where ppa.business_group_id + 0 = g_business_group_id
6102: and ppa.action_status = 'C'
6103: and ppa.action_type in ('R', 'Q', 'B', 'I')
6104: and decode(nvl(ppa.element_set_id,-1),

Line 6170: pay_element_entry_values_f peev_itax_org2,

6166: pay_link_input_values_f pliv_itax_org2,
6167: pay_link_input_values_f pliv_itax_type2,
6168: pay_element_entries_f pee_itax_org2,
6169: pay_element_entries_f pee_itax_type2,
6170: pay_element_entry_values_f peev_itax_org2,
6171: pay_element_entry_values_f peev_itax_type2
6172: where ppa2.business_group_id + 0 = g_business_group_id
6173: and ppa2.action_status = 'C'
6174: and ppa2.action_type in ('R', 'Q', 'B', 'I')

Line 6171: pay_element_entry_values_f peev_itax_type2

6167: pay_link_input_values_f pliv_itax_type2,
6168: pay_element_entries_f pee_itax_org2,
6169: pay_element_entries_f pee_itax_type2,
6170: pay_element_entry_values_f peev_itax_org2,
6171: pay_element_entry_values_f peev_itax_type2
6172: where ppa2.business_group_id + 0 = g_business_group_id
6173: and ppa2.action_status = 'C'
6174: and ppa2.action_type in ('R', 'Q', 'B', 'I')
6175: and decode(nvl(ppa2.element_set_id,-1),

Line 6249: pay_element_entry_values_f peev_itax_org,

6245: pay_link_input_values_f pliv_itax_org,
6246: pay_link_input_values_f pliv_itax_type,
6247: pay_element_entries_f pee_itax_org,
6248: pay_element_entries_f pee_itax_type,
6249: pay_element_entry_values_f peev_itax_org,
6250: pay_element_entry_values_f peev_itax_type
6251: where ppa.business_group_id + 0 = g_business_group_id
6252: and ppa.action_status = 'C'
6253: and ppa.action_type in ('R', 'Q', 'B', 'I')

Line 6250: pay_element_entry_values_f peev_itax_type

6246: pay_link_input_values_f pliv_itax_type,
6247: pay_element_entries_f pee_itax_org,
6248: pay_element_entries_f pee_itax_type,
6249: pay_element_entry_values_f peev_itax_org,
6250: pay_element_entry_values_f peev_itax_type
6251: where ppa.business_group_id + 0 = g_business_group_id
6252: and ppa.action_status = 'C'
6253: and ppa.action_type in ('R', 'Q', 'B', 'I')
6254: and decode(nvl(ppa.element_set_id,-1),

Line 6320: pay_element_entry_values_f peev_itax_org2,

6316: pay_link_input_values_f pliv_itax_org2,
6317: pay_link_input_values_f pliv_itax_type2,
6318: pay_element_entries_f pee_itax_org2,
6319: pay_element_entries_f pee_itax_type2,
6320: pay_element_entry_values_f peev_itax_org2,
6321: pay_element_entry_values_f peev_itax_type2
6322: where ppa2.business_group_id + 0 = g_business_group_id
6323: and ppa2.action_status = 'C'
6324: and ppa2.action_type in ('R', 'Q', 'B', 'I')

Line 6321: pay_element_entry_values_f peev_itax_type2

6317: pay_link_input_values_f pliv_itax_type2,
6318: pay_element_entries_f pee_itax_org2,
6319: pay_element_entries_f pee_itax_type2,
6320: pay_element_entry_values_f peev_itax_org2,
6321: pay_element_entry_values_f peev_itax_type2
6322: where ppa2.business_group_id + 0 = g_business_group_id
6323: and ppa2.action_status = 'C'
6324: and ppa2.action_type in ('R', 'Q', 'B', 'I')
6325: and decode(nvl(ppa2.element_set_id,-1),

Line 6422: pay_element_entry_values_f peev_itax_org,

6418: pay_link_input_values_f pliv_itax_org,
6419: pay_link_input_values_f pliv_itax_type,
6420: pay_element_entries_f pee_itax_org,
6421: pay_element_entries_f pee_itax_type,
6422: pay_element_entry_values_f peev_itax_org,
6423: pay_element_entry_values_f peev_itax_type
6424: where ppa.business_group_id + 0 = g_business_group_id
6425: and ppa.action_status = 'C'
6426: and ppa.action_type in ('R', 'Q', 'B', 'I')

Line 6423: pay_element_entry_values_f peev_itax_type

6419: pay_link_input_values_f pliv_itax_type,
6420: pay_element_entries_f pee_itax_org,
6421: pay_element_entries_f pee_itax_type,
6422: pay_element_entry_values_f peev_itax_org,
6423: pay_element_entry_values_f peev_itax_type
6424: where ppa.business_group_id + 0 = g_business_group_id
6425: and ppa.action_status = 'C'
6426: and ppa.action_type in ('R', 'Q', 'B', 'I')
6427: and decode(nvl(ppa.element_set_id,-1),

Line 6495: pay_element_entry_values_f peev_itax_org2,

6491: pay_link_input_values_f pliv_itax_org2,
6492: pay_link_input_values_f pliv_itax_type2,
6493: pay_element_entries_f pee_itax_org2,
6494: pay_element_entries_f pee_itax_type2,
6495: pay_element_entry_values_f peev_itax_org2,
6496: pay_element_entry_values_f peev_itax_type2
6497: where ppa2.business_group_id + 0 = g_business_group_id
6498: and ppa2.action_status = 'C'
6499: and ppa2.action_type in ('R', 'Q', 'B', 'I')

Line 6496: pay_element_entry_values_f peev_itax_type2

6492: pay_link_input_values_f pliv_itax_type2,
6493: pay_element_entries_f pee_itax_org2,
6494: pay_element_entries_f pee_itax_type2,
6495: pay_element_entry_values_f peev_itax_org2,
6496: pay_element_entry_values_f peev_itax_type2
6497: where ppa2.business_group_id + 0 = g_business_group_id
6498: and ppa2.action_status = 'C'
6499: and ppa2.action_type in ('R', 'Q', 'B', 'I')
6500: and decode(nvl(ppa2.element_set_id,-1),

Line 6596: pay_element_entry_values_f peev_itax_org,

6592: pay_link_input_values_f pliv_itax_org,
6593: pay_link_input_values_f pliv_itax_type,
6594: pay_element_entries_f pee_itax_org,
6595: pay_element_entries_f pee_itax_type,
6596: pay_element_entry_values_f peev_itax_org,
6597: pay_element_entry_values_f peev_itax_type
6598: where ppa.business_group_id + 0 = g_business_group_id
6599: and ppa.action_status = 'C'
6600: and ppa.action_type in ('R', 'Q', 'B', 'I')

Line 6597: pay_element_entry_values_f peev_itax_type

6593: pay_link_input_values_f pliv_itax_type,
6594: pay_element_entries_f pee_itax_org,
6595: pay_element_entries_f pee_itax_type,
6596: pay_element_entry_values_f peev_itax_org,
6597: pay_element_entry_values_f peev_itax_type
6598: where ppa.business_group_id + 0 = g_business_group_id
6599: and ppa.action_status = 'C'
6600: and ppa.action_type in ('R', 'Q', 'B', 'I')
6601: and decode(nvl(ppa.element_set_id,-1),

Line 6669: pay_element_entry_values_f peev_itax_org2,

6665: pay_link_input_values_f pliv_itax_org2,
6666: pay_link_input_values_f pliv_itax_type2,
6667: pay_element_entries_f pee_itax_org2,
6668: pay_element_entries_f pee_itax_type2,
6669: pay_element_entry_values_f peev_itax_org2,
6670: pay_element_entry_values_f peev_itax_type2
6671: where ppa2.business_group_id + 0 = g_business_group_id
6672: and ppa2.action_status = 'C'
6673: and ppa2.action_type in ('R', 'Q', 'B', 'I')

Line 6670: pay_element_entry_values_f peev_itax_type2

6666: pay_link_input_values_f pliv_itax_type2,
6667: pay_element_entries_f pee_itax_org2,
6668: pay_element_entries_f pee_itax_type2,
6669: pay_element_entry_values_f peev_itax_org2,
6670: pay_element_entry_values_f peev_itax_type2
6671: where ppa2.business_group_id + 0 = g_business_group_id
6672: and ppa2.action_status = 'C'
6673: and ppa2.action_type in ('R', 'Q', 'B', 'I')
6674: and decode(nvl(ppa2.element_set_id,-1),

Line 7493: pay_element_entry_values_f peev_itax_org,

7489: pay_link_input_values_f pliv_itax_org,
7490: pay_link_input_values_f pliv_itax_type,
7491: pay_element_entries_f pee_itax_org,
7492: pay_element_entries_f pee_itax_type,
7493: pay_element_entry_values_f peev_itax_org,
7494: pay_element_entry_values_f peev_itax_type
7495: where ppa_arch.payroll_action_id = p_payroll_action_id
7496: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
7497: and paa.assignment_id = paa_arch.assignment_id

Line 7494: pay_element_entry_values_f peev_itax_type

7490: pay_link_input_values_f pliv_itax_type,
7491: pay_element_entries_f pee_itax_org,
7492: pay_element_entries_f pee_itax_type,
7493: pay_element_entry_values_f peev_itax_org,
7494: pay_element_entry_values_f peev_itax_type
7495: where ppa_arch.payroll_action_id = p_payroll_action_id
7496: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
7497: and paa.assignment_id = paa_arch.assignment_id
7498: and paa.action_status = 'C'

Line 7564: -- pay_element_entry_values_f peev_itax_org2,

7560: -- pay_link_input_values_f pliv_itax_org2,
7561: -- pay_link_input_values_f pliv_itax_type2,
7562: -- pay_element_entries_f pee_itax_org2,
7563: -- pay_element_entries_f pee_itax_type2,
7564: -- pay_element_entry_values_f peev_itax_org2,
7565: -- pay_element_entry_values_f peev_itax_type2
7566: -- where ppa2.action_status = 'C'
7567: -- and ppa2.action_type in ('R','Q')
7568: -- and ppa2.effective_date

Line 7565: -- pay_element_entry_values_f peev_itax_type2

7561: -- pay_link_input_values_f pliv_itax_type2,
7562: -- pay_element_entries_f pee_itax_org2,
7563: -- pay_element_entries_f pee_itax_type2,
7564: -- pay_element_entry_values_f peev_itax_org2,
7565: -- pay_element_entry_values_f peev_itax_type2
7566: -- where ppa2.action_status = 'C'
7567: -- and ppa2.action_type in ('R','Q')
7568: -- and ppa2.effective_date
7569: -- between g_effective_som and g_effective_eom

Line 7732: pay_element_entry_values_f peev_itax_org,

7728: pay_link_input_values_f pliv_itax_org,
7729: pay_link_input_values_f pliv_itax_type,
7730: pay_element_entries_f pee_itax_org,
7731: pay_element_entries_f pee_itax_type,
7732: pay_element_entry_values_f peev_itax_org,
7733: pay_element_entry_values_f peev_itax_type
7734: where paa.assignment_id = larch_v.assignment_id
7735: and paa.action_status = 'C'
7736: and ppa.payroll_action_id = paa.payroll_action_id

Line 7733: pay_element_entry_values_f peev_itax_type

7729: pay_link_input_values_f pliv_itax_type,
7730: pay_element_entries_f pee_itax_org,
7731: pay_element_entries_f pee_itax_type,
7732: pay_element_entry_values_f peev_itax_org,
7733: pay_element_entry_values_f peev_itax_type
7734: where paa.assignment_id = larch_v.assignment_id
7735: and paa.action_status = 'C'
7736: and ppa.payroll_action_id = paa.payroll_action_id
7737: and ppa.action_status = 'C'

Line 7803: -- pay_element_entry_values_f peev_itax_org2,

7799: -- pay_link_input_values_f pliv_itax_org2,
7800: -- pay_link_input_values_f pliv_itax_type2,
7801: -- pay_element_entries_f pee_itax_org2,
7802: -- pay_element_entries_f pee_itax_type2,
7803: -- pay_element_entry_values_f peev_itax_org2,
7804: -- pay_element_entry_values_f peev_itax_type2
7805: -- where paa2.assignment_id = paa.assignment_id
7806: -- and paa2.action_status = 'C'
7807: -- and ppa2.payroll_action_id = paa2.payroll_action_id

Line 7804: -- pay_element_entry_values_f peev_itax_type2

7800: -- pay_link_input_values_f pliv_itax_type2,
7801: -- pay_element_entries_f pee_itax_org2,
7802: -- pay_element_entries_f pee_itax_type2,
7803: -- pay_element_entry_values_f peev_itax_org2,
7804: -- pay_element_entry_values_f peev_itax_type2
7805: -- where paa2.assignment_id = paa.assignment_id
7806: -- and paa2.action_status = 'C'
7807: -- and ppa2.payroll_action_id = paa2.payroll_action_id
7808: -- and ppa2.action_status = 'C'

Line 8008: pay_element_entry_values_f peev_itax_org,

8004: pay_link_input_values_f pliv_itax_org,
8005: pay_link_input_values_f pliv_itax_type,
8006: pay_element_entries_f pee_itax_org,
8007: pay_element_entries_f pee_itax_type,
8008: pay_element_entry_values_f peev_itax_org,
8009: pay_element_entry_values_f peev_itax_type
8010: where paa.assignment_id = larch_v.assignment_id
8011: and paa.action_status = 'C'
8012: and ppa.payroll_action_id = paa.payroll_action_id

Line 8009: pay_element_entry_values_f peev_itax_type

8005: pay_link_input_values_f pliv_itax_type,
8006: pay_element_entries_f pee_itax_org,
8007: pay_element_entries_f pee_itax_type,
8008: pay_element_entry_values_f peev_itax_org,
8009: pay_element_entry_values_f peev_itax_type
8010: where paa.assignment_id = larch_v.assignment_id
8011: and paa.action_status = 'C'
8012: and ppa.payroll_action_id = paa.payroll_action_id
8013: and ppa.action_status = 'C'

Line 8077: -- pay_element_entry_values_f peev_itax_org2,

8073: -- pay_link_input_values_f pliv_itax_org2,
8074: -- pay_link_input_values_f pliv_itax_type2,
8075: -- pay_element_entries_f pee_itax_org2,
8076: -- pay_element_entries_f pee_itax_type2,
8077: -- pay_element_entry_values_f peev_itax_org2,
8078: -- pay_element_entry_values_f peev_itax_type2
8079: -- where paa2.assignment_id = paa.assignment_id
8080: -- and paa2.action_status = 'C'
8081: -- and ppa2.payroll_action_id = paa2.payroll_action_id

Line 8078: -- pay_element_entry_values_f peev_itax_type2

8074: -- pay_link_input_values_f pliv_itax_type2,
8075: -- pay_element_entries_f pee_itax_org2,
8076: -- pay_element_entries_f pee_itax_type2,
8077: -- pay_element_entry_values_f peev_itax_org2,
8078: -- pay_element_entry_values_f peev_itax_type2
8079: -- where paa2.assignment_id = paa.assignment_id
8080: -- and paa2.action_status = 'C'
8081: -- and ppa2.payroll_action_id = paa2.payroll_action_id
8082: -- and ppa2.action_status = 'C'