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 PAY_ASSIGNMENT_ACTIONS

Line 934: pay_assignment_actions paa,

930: from pay_balance_feeds_f pbff,
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

Line 964: pay_assignment_actions paa,

960: from pay_balance_feeds_f pbff,
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

Line 4912: pay_assignment_actions paa,

4908: from pay_balance_feeds_f pbff,
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

Line 4945: pay_assignment_actions paa,

4941: from pay_balance_feeds_f pbff,
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

Line 4980: pay_assignment_actions paa,

4976: from pay_balance_feeds_f pbff,
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

Line 5011: pay_assignment_actions paa,

5007: from pay_balance_feeds_f pbff,
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

Line 5063: pay_assignment_actions paa,

5059: into g_assignments_table(l_assignment.assignment_id).annual_income
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

Line 6317: pay_assignment_actions paa,

6313: from pay_balance_feeds_f pbff,
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

Line 6350: pay_assignment_actions paa,

6346: from pay_balance_feeds_f pbff,
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

Line 6385: pay_assignment_actions paa,

6381: from pay_balance_feeds_f pbff,
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

Line 6416: pay_assignment_actions paa,

6412: from pay_balance_feeds_f pbff,
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

Line 6479: pay_assignment_actions paa,

6475: into g_new_assignments_table(l_assignment.assignment_id).annual_income
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