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.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ASSIGNMENTS_F

Line 888: per_assignments_f asg --Bug 4872110

884: pay_run_result_values prrv,
885: pay_run_results prr,
886: pay_payroll_actions ppa,
887: pay_assignment_actions paa,
888: per_assignments_f asg --Bug 4872110
889: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
890: where paa.assignment_id = l_assignment.assignment_id
891: and ppa.payroll_action_id = paa.payroll_action_id
892: and ppa.date_earned between l_report_start and l_report_end

Line 918: per_assignments_f asg --Bug 4872110

914: pay_run_result_values prrv,
915: pay_run_results prr,
916: pay_payroll_actions ppa,
917: pay_assignment_actions paa,
918: per_assignments_f asg --Bug 4872110
919: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
920: where paa.assignment_id = l_assignment.assignment_id
921: and ppa.payroll_action_id = paa.payroll_action_id
922: and ppa.date_earned between l_report_start and l_report_end

Line 4785: per_assignments_f asg --Bug 4872110

4781: pay_run_result_values prrv,
4782: pay_run_results prr,
4783: pay_payroll_actions ppa,
4784: pay_assignment_actions paa,
4785: per_assignments_f asg --Bug 4872110
4786: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
4787: where paa.assignment_id = l_assignment.assignment_id
4788: and ppa.payroll_action_id = paa.payroll_action_id
4789: and ppa.date_earned between l_report_start and l_report_end

Line 4816: per_assignments_f asg --Bug 4872110

4812: pay_run_result_values prrv,
4813: pay_run_results prr,
4814: pay_payroll_actions ppa,
4815: pay_assignment_actions paa,
4816: per_assignments_f asg --Bug 4872110
4817: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
4818: where paa.assignment_id = l_assignment.assignment_id
4819: and ppa.payroll_action_id = paa.payroll_action_id
4820: and ppa.date_earned between l_report_start and l_report_end

Line 4849: per_assignments_f asg

4845: pay_run_result_values prrv,
4846: pay_run_results prr,
4847: pay_payroll_actions ppa,
4848: pay_assignment_actions paa,
4849: per_assignments_f asg
4850: where paa.assignment_id = l_assignment.assignment_id
4851: and ppa.payroll_action_id = paa.payroll_action_id
4852: and ppa.date_earned between l_report_start and l_report_end
4853: and prr.assignment_action_id = paa.assignment_action_id

Line 4878: per_assignments_f asg --Bug 4872110

4874: pay_run_result_values prrv,
4875: pay_run_results prr,
4876: pay_payroll_actions ppa,
4877: pay_assignment_actions paa,
4878: per_assignments_f asg --Bug 4872110
4879: where paa.assignment_id = l_assignment.assignment_id
4880: and ppa.payroll_action_id = paa.payroll_action_id
4881: and ppa.date_earned between l_report_start and l_report_end
4882: and prr.assignment_action_id = paa.assignment_action_id