DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 886: pay_payroll_actions ppa,

882: into l_ee_income
883: from pay_balance_feeds_f pbff,
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

Line 916: pay_payroll_actions ppa,

912: into l_ee_annual_income
913: from pay_balance_feeds_f pbff,
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

Line 4783: pay_payroll_actions ppa,

4779: into l_ee_income
4780: from pay_balance_feeds_f pbff,
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

Line 4814: pay_payroll_actions ppa,

4810: into l_ee_annual_income
4811: from pay_balance_feeds_f pbff,
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

Line 4847: pay_payroll_actions ppa,

4843: into l_er_income
4844: from pay_balance_feeds_f pbff,
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

Line 4876: pay_payroll_actions ppa,

4872: into l_er_annual_income
4873: from pay_balance_feeds_f pbff,
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