DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 930: from pay_balance_feeds_f pbff,

926: begin
927:
928: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 960: from pay_balance_feeds_f pbff,

956: begin
957:
958: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 4908: from pay_balance_feeds_f pbff,

4904: begin
4905:
4906: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 4941: from pay_balance_feeds_f pbff,

4937: begin
4938:
4939: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 4976: from pay_balance_feeds_f pbff,

4972: begin
4973:
4974: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 5007: from pay_balance_feeds_f pbff,

5003: begin
5004:
5005: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 6313: from pay_balance_feeds_f pbff,

6309: begin
6310:
6311: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 6346: from pay_balance_feeds_f pbff,

6342: begin
6343:
6344: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 6381: from pay_balance_feeds_f pbff,

6377: begin
6378:
6379: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,

Line 6412: from pay_balance_feeds_f pbff,

6408: begin
6409:
6410: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbff.scale), 0)
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,