APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 6097: pay_element_entries_f pee_itax_org,

6093: pay_assignment_actions paa,
6094: per_all_assignments_f pa,
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

Line 6098: pay_element_entries_f pee_itax_type,

6094: per_all_assignments_f pa,
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'

Line 6168: pay_element_entries_f pee_itax_org2,

6164: from pay_payroll_actions ppa2,
6165: pay_assignment_actions paa2,
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

Line 6169: pay_element_entries_f pee_itax_type2,

6165: pay_assignment_actions paa2,
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'

Line 6247: pay_element_entries_f pee_itax_org,

6243: pay_assignment_actions paa,
6244: per_all_assignments_f pa,
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

Line 6248: pay_element_entries_f pee_itax_type,

6244: per_all_assignments_f pa,
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'

Line 6318: pay_element_entries_f pee_itax_org2,

6314: from pay_payroll_actions ppa2,
6315: pay_assignment_actions paa2,
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

Line 6319: pay_element_entries_f pee_itax_type2,

6315: pay_assignment_actions paa2,
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'

Line 6420: pay_element_entries_f pee_itax_org,

6416: pay_assignment_actions paa,
6417: per_all_assignments_f pa,
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

Line 6421: pay_element_entries_f pee_itax_type,

6417: per_all_assignments_f pa,
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'

Line 6493: pay_element_entries_f pee_itax_org2,

6489: pay_assignment_actions paa2,
6490: per_all_assignments_f pa2,
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

Line 6494: pay_element_entries_f pee_itax_type2,

6490: per_all_assignments_f pa2,
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'

Line 6594: pay_element_entries_f pee_itax_org,

6590: pay_assignment_actions paa,
6591: per_all_assignments_f pa,
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

Line 6595: pay_element_entries_f pee_itax_type,

6591: per_all_assignments_f pa,
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'

Line 6667: pay_element_entries_f pee_itax_org2,

6663: pay_assignment_actions paa2,
6664: per_all_assignments_f pa2,
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

Line 6668: pay_element_entries_f pee_itax_type2,

6664: per_all_assignments_f pa2,
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'

Line 7491: pay_element_entries_f pee_itax_org,

7487: pay_assignment_actions paa,
7488: pay_payroll_actions ppa,
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

Line 7492: pay_element_entries_f pee_itax_type,

7488: pay_payroll_actions ppa,
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

Line 7562: -- pay_element_entries_f pee_itax_org2,

7558: -- from pay_payroll_actions ppa2,
7559: -- pay_assignment_actions paa2,
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'

Line 7563: -- pay_element_entries_f pee_itax_type2,

7559: -- pay_assignment_actions paa2,
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')

Line 7730: pay_element_entries_f pee_itax_org,

7726: pay_assignment_actions paa,
7727: pay_payroll_actions ppa,
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

Line 7731: pay_element_entries_f pee_itax_type,

7727: pay_payroll_actions ppa,
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'

Line 7801: -- pay_element_entries_f pee_itax_org2,

7797: -- from pay_assignment_actions paa2,
7798: -- pay_payroll_actions ppa2,
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

Line 7802: -- pay_element_entries_f pee_itax_type2,

7798: -- pay_payroll_actions ppa2,
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'

Line 8006: pay_element_entries_f pee_itax_org,

8002: pay_assignment_actions paa,
8003: pay_payroll_actions ppa,
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

Line 8007: pay_element_entries_f pee_itax_type,

8003: pay_payroll_actions ppa,
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'

Line 8075: -- pay_element_entries_f pee_itax_org2,

8071: -- from pay_assignment_actions paa2,
8072: -- pay_payroll_actions ppa2,
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

Line 8076: -- pay_element_entries_f pee_itax_type2,

8072: -- pay_payroll_actions ppa2,
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'