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 935: per_assignments_f asg --Bug 4872110

931: pay_run_result_values prrv,
932: pay_run_results prr,
933: pay_payroll_actions ppa,
934: pay_assignment_actions paa,
935: per_assignments_f asg --Bug 4872110
936: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
937: where paa.assignment_id = l_assignment.assignment_id
938: and ppa.payroll_action_id = paa.payroll_action_id
939: and ppa.date_earned between l_report_start and l_report_end

Line 965: per_assignments_f asg --Bug 4872110

961: pay_run_result_values prrv,
962: pay_run_results prr,
963: pay_payroll_actions ppa,
964: pay_assignment_actions paa,
965: per_assignments_f asg --Bug 4872110
966: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
967: where paa.assignment_id = l_assignment.assignment_id
968: and ppa.payroll_action_id = paa.payroll_action_id
969: and ppa.date_earned between l_report_start and l_report_end

Line 4913: per_assignments_f asg --Bug 4872110

4909: pay_run_result_values prrv,
4910: pay_run_results prr,
4911: pay_payroll_actions ppa,
4912: pay_assignment_actions paa,
4913: per_assignments_f asg --Bug 4872110
4914: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
4915: where paa.assignment_id = l_assignment.assignment_id
4916: and ppa.payroll_action_id = paa.payroll_action_id
4917: -- Bug 8911880

Line 4946: per_assignments_f asg --Bug 4872110

4942: pay_run_result_values prrv,
4943: pay_run_results prr,
4944: pay_payroll_actions ppa,
4945: pay_assignment_actions paa,
4946: per_assignments_f asg --Bug 4872110
4947: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
4948: where paa.assignment_id = l_assignment.assignment_id
4949: and ppa.payroll_action_id = paa.payroll_action_id
4950: -- Bug 8911880

Line 4981: per_assignments_f asg

4977: pay_run_result_values prrv,
4978: pay_run_results prr,
4979: pay_payroll_actions ppa,
4980: pay_assignment_actions paa,
4981: per_assignments_f asg
4982: where paa.assignment_id = l_assignment.assignment_id
4983: and ppa.payroll_action_id = paa.payroll_action_id
4984: -- Bug 8911880
4985: -- and ppa.date_earned between l_report_start and l_report_end

Line 5012: per_assignments_f asg --Bug 4872110

5008: pay_run_result_values prrv,
5009: pay_run_results prr,
5010: pay_payroll_actions ppa,
5011: pay_assignment_actions paa,
5012: per_assignments_f asg --Bug 4872110
5013: where paa.assignment_id = l_assignment.assignment_id
5014: and ppa.payroll_action_id = paa.payroll_action_id
5015: -- Bug 8911880
5016: -- and ppa.date_earned between l_report_start and l_report_end

Line 5064: per_assignments_f asg

5060: from pay_run_result_values prrv,
5061: pay_run_results prr,
5062: pay_payroll_actions ppa,
5063: pay_assignment_actions paa,
5064: per_assignments_f asg
5065: where paa.assignment_id = l_assignment.assignment_id
5066: and ppa.payroll_action_id = paa.payroll_action_id
5067: and ppa.date_earned between add_months(p_report_date,-12)+1 and p_report_date
5068: and prr.assignment_action_id = paa.assignment_action_id

Line 6318: per_assignments_f asg --Bug 4872110

6314: pay_run_result_values prrv,
6315: pay_run_results prr,
6316: pay_payroll_actions ppa,
6317: pay_assignment_actions paa,
6318: per_assignments_f asg --Bug 4872110
6319: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
6320: where paa.assignment_id = l_assignment.assignment_id
6321: and ppa.payroll_action_id = paa.payroll_action_id
6322: -- Bug 8911880

Line 6351: per_assignments_f asg --Bug 4872110

6347: pay_run_result_values prrv,
6348: pay_run_results prr,
6349: pay_payroll_actions ppa,
6350: pay_assignment_actions paa,
6351: per_assignments_f asg --Bug 4872110
6352: -- BUG 2665394 ADDED THE TABLE TO IMPROVE THE PERFORMANCE
6353: where paa.assignment_id = l_assignment.assignment_id
6354: and ppa.payroll_action_id = paa.payroll_action_id
6355: -- Bug 8911880

Line 6386: per_assignments_f asg

6382: pay_run_result_values prrv,
6383: pay_run_results prr,
6384: pay_payroll_actions ppa,
6385: pay_assignment_actions paa,
6386: per_assignments_f asg
6387: where paa.assignment_id = l_assignment.assignment_id
6388: and ppa.payroll_action_id = paa.payroll_action_id
6389: -- Bug 8911880
6390: -- and ppa.date_earned between l_report_start and l_report_end

Line 6417: per_assignments_f asg --Bug 4872110

6413: pay_run_result_values prrv,
6414: pay_run_results prr,
6415: pay_payroll_actions ppa,
6416: pay_assignment_actions paa,
6417: per_assignments_f asg --Bug 4872110
6418: where paa.assignment_id = l_assignment.assignment_id
6419: and ppa.payroll_action_id = paa.payroll_action_id
6420: -- Bug 8911880
6421: -- and ppa.date_earned between l_report_start and l_report_end

Line 6480: per_assignments_f asg

6476: from pay_run_result_values prrv,
6477: pay_run_results prr,
6478: pay_payroll_actions ppa,
6479: pay_assignment_actions paa,
6480: per_assignments_f asg
6481: where paa.assignment_id = l_assignment.assignment_id
6482: and ppa.payroll_action_id = paa.payroll_action_id
6483: and ppa.date_earned between add_months(p_report_date,-12)+1 and p_report_date
6484: and prr.assignment_action_id = paa.assignment_action_id