eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 6094: per_all_assignments_f pa,

6090: pa.person_id,
6091: paa.assignment_id
6092: from pay_payroll_actions ppa,
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,

Line 6244: per_all_assignments_f pa,

6240: pa.person_id,
6241: ppa.effective_date
6242: from pay_payroll_actions ppa,
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,

Line 6417: per_all_assignments_f pa,

6413: pa.person_id,
6414: ppa.effective_date
6415: from pay_payroll_actions ppa,
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,

Line 6490: per_all_assignments_f pa2,

6486: select /*+ ORDERED */
6487: null
6488: from pay_payroll_actions ppa2,
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,

Line 6591: per_all_assignments_f pa,

6587: pa.person_id,
6588: ppa.effective_date
6589: from pay_payroll_actions ppa,
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,

Line 6664: per_all_assignments_f pa2,

6660: select /*+ ORDERED */
6661: null
6662: from pay_payroll_actions ppa2,
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,

Line 7617: per_all_assignments_f pa,

7613: -- and peev_itax_type2.effective_end_date = pee_itax_type2.effective_end_date
7614: -- and peev_itax_type2.screen_entry_value <> 'E'
7615: -- and paa2.action_sequence > paa.action_sequence) */
7616: ) proc_v,
7617: per_all_assignments_f pa,
7618: per_all_people_f pp,
7619: per_periods_of_service ppos,
7620: pay_all_payrolls_f ppy
7621: where pa.assignment_id = proc_v.assignment_id

Line 8130: per_all_assignments_f pa,

8126: -- and peev_itax_type2.effective_end_date = pee_itax_type2.effective_end_date
8127: -- and peev_itax_type2.screen_entry_value <> 'E'
8128: -- and paa2.action_sequence > paa.action_sequence) */
8129: ) proc_v,
8130: per_all_assignments_f pa,
8131: per_all_people_f pp,
8132: per_periods_of_service ppos,
8133: pay_all_payrolls_f ppy
8134: where pa.assignment_id = proc_v.assignment_id

Line 8229: from per_all_assignments_f pa,

8225: ppos.date_start,
8226: ppos.leaving_reason,
8227: pp.sex,
8228: pp.date_of_birth
8229: from per_all_assignments_f pa,
8230: per_all_people_f pp,
8231: per_periods_of_service ppos
8232: where pa.assignment_id = p_assignment_id
8233: and p_effective_date