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_BALANCE_TYPES

Line 696: l_ee_balance_type_id pay_balance_types.balance_type_id%type;

692: l_report_end date;
693: l_report_date date;
694: l_difference number;
695: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
696: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
697: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
698: l_input_value_id pay_input_values_f.input_value_id%type;
699: l_index number;
700: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';

Line 697: l_eea_balance_type_id pay_balance_types.balance_type_id%type;

693: l_report_date date;
694: l_difference number;
695: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
696: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
697: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
698: l_input_value_id pay_input_values_f.input_value_id%type;
699: l_index number;
700: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
701: l_race per_all_people_f.per_information4%type; -- Bug 4413678

Line 722: from pay_balance_types

718: begin
719:
720: select balance_type_id
721: into l_ee_balance_type_id
722: from pay_balance_types
723: where balance_name = 'Total Employment Equityable Income'
724: and legislation_code = 'ZA'
725: and business_group_id is null;
726:

Line 729: from pay_balance_types

725: and business_group_id is null;
726:
727: select balance_type_id
728: into l_eea_balance_type_id
729: from pay_balance_types
730: where balance_name = 'Total Employment Equityable Annual Income'
731: and legislation_code = 'ZA'
732: and business_group_id is null;
733:

Line 4566: l_ee_balance_type_id pay_balance_types.balance_type_id%type;

4562: l_report_end date;
4563: l_report_date date;
4564: l_difference number;
4565: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
4566: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
4567: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
4568: l_input_value_id pay_input_values_f.input_value_id%type;
4569: l_index number;
4570: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';

Line 4567: l_eea_balance_type_id pay_balance_types.balance_type_id%type;

4563: l_report_date date;
4564: l_difference number;
4565: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
4566: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
4567: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
4568: l_input_value_id pay_input_values_f.input_value_id%type;
4569: l_index number;
4570: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
4571: l_race per_all_people_f.per_information4%type; -- Bug 4413678

Line 4576: l_er_balance_type_id pay_balance_types.balance_type_id%type;

4572: l_sex per_all_people_f.sex%type;
4573: --Changes for Bug 7237663
4574: l_er_income number;
4575: l_er_annual_income number;
4576: l_er_balance_type_id pay_balance_types.balance_type_id%type;
4577: l_era_balance_type_id pay_balance_types.balance_type_id%type;
4578:
4579:
4580: begin

Line 4577: l_era_balance_type_id pay_balance_types.balance_type_id%type;

4573: --Changes for Bug 7237663
4574: l_er_income number;
4575: l_er_annual_income number;
4576: l_er_balance_type_id pay_balance_types.balance_type_id%type;
4577: l_era_balance_type_id pay_balance_types.balance_type_id%type;
4578:
4579:
4580: begin
4581: --hr_utility.trace_on(null,'ZAEID');

Line 4600: from pay_balance_types

4596: begin
4597:
4598: select balance_type_id
4599: into l_ee_balance_type_id
4600: from pay_balance_types
4601: where balance_name = 'Total Employment Equityable Income'
4602: and legislation_code = 'ZA'
4603: and business_group_id is null;
4604:

Line 4607: from pay_balance_types

4603: and business_group_id is null;
4604:
4605: select balance_type_id
4606: into l_eea_balance_type_id
4607: from pay_balance_types
4608: where balance_name = 'Total Employment Equityable Annual Income'
4609: and legislation_code = 'ZA'
4610: and business_group_id is null;
4611:

Line 4615: from pay_balance_types

4611:
4612: --Changes for Bug 7237663
4613: select balance_type_id
4614: into l_er_balance_type_id
4615: from pay_balance_types
4616: where balance_name = 'Total Employment Equityable ER Normal Contributions'
4617: and legislation_code = 'ZA'
4618: and business_group_id is null;
4619:

Line 4622: from pay_balance_types

4618: and business_group_id is null;
4619:
4620: select balance_type_id
4621: into l_era_balance_type_id
4622: from pay_balance_types
4623: where balance_name = 'Total Employment Equityable ER Annual Contributions'
4624: and legislation_code = 'ZA'
4625: and business_group_id is null;
4626: --End changes for Bug 7237663