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_PAYROLL_ACTIONS

Line 933: pay_payroll_actions ppa,

929: into l_ee_income
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

Line 963: pay_payroll_actions ppa,

959: into l_ee_annual_income
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

Line 4911: pay_payroll_actions ppa,

4907: into l_ee_income
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

Line 4944: pay_payroll_actions ppa,

4940: into l_ee_annual_income
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

Line 4979: pay_payroll_actions ppa,

4975: into l_er_income
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

Line 5010: pay_payroll_actions ppa,

5006: into l_er_annual_income
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

Line 5062: pay_payroll_actions ppa,

5058: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value)), 0)
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

Line 6316: pay_payroll_actions ppa,

6312: into l_ee_income
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

Line 6349: pay_payroll_actions ppa,

6345: into l_ee_annual_income
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

Line 6384: pay_payroll_actions ppa,

6380: into l_er_income
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

Line 6415: pay_payroll_actions ppa,

6411: into l_er_annual_income
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

Line 6478: pay_payroll_actions ppa,

6474: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value)), 0)
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