APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_BALANCE_TYPES

Line 743: l_ee_balance_type_id pay_balance_types.balance_type_id%type;

739: l_report_end date;
740: l_report_date date;
741: l_difference number;
742: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
743: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
744: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
745: l_input_value_id pay_input_values_f.input_value_id%type;
746: l_index number;
747: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';

Line 744: l_eea_balance_type_id pay_balance_types.balance_type_id%type;

740: l_report_date date;
741: l_difference number;
742: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
743: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
744: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
745: l_input_value_id pay_input_values_f.input_value_id%type;
746: l_index number;
747: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
748: l_race per_all_people_f.per_information4%type; -- Bug 4413678

Line 769: from pay_balance_types

765: begin
766:
767: select balance_type_id
768: into l_ee_balance_type_id
769: from pay_balance_types
770: where balance_name = 'Total Employment Equityable Income'
771: and legislation_code = 'ZA'
772: and business_group_id is null;
773:

Line 776: from pay_balance_types

772: and business_group_id is null;
773:
774: select balance_type_id
775: into l_eea_balance_type_id
776: from pay_balance_types
777: where balance_name = 'Total Employment Equityable Annual Income'
778: and legislation_code = 'ZA'
779: and business_group_id is null;
780:

Line 4688: l_ee_balance_type_id pay_balance_types.balance_type_id%type;

4684: l_report_end date;
4685: l_report_date date;
4686: l_difference number;
4687: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
4688: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
4689: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
4690: l_input_value_id pay_input_values_f.input_value_id%type;
4691: l_index number;
4692: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';

Line 4689: l_eea_balance_type_id pay_balance_types.balance_type_id%type;

4685: l_report_date date;
4686: l_difference number;
4687: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
4688: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
4689: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
4690: l_input_value_id pay_input_values_f.input_value_id%type;
4691: l_index number;
4692: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
4693: l_race per_all_people_f.per_information4%type; -- Bug 4413678

Line 4698: l_er_balance_type_id pay_balance_types.balance_type_id%type;

4694: l_sex per_all_people_f.sex%type;
4695: --Changes for Bug 7237663
4696: l_er_income number;
4697: l_er_annual_income number;
4698: l_er_balance_type_id pay_balance_types.balance_type_id%type;
4699: l_era_balance_type_id pay_balance_types.balance_type_id%type;
4700:
4701:
4702: begin

Line 4699: l_era_balance_type_id pay_balance_types.balance_type_id%type;

4695: --Changes for Bug 7237663
4696: l_er_income number;
4697: l_er_annual_income number;
4698: l_er_balance_type_id pay_balance_types.balance_type_id%type;
4699: l_era_balance_type_id pay_balance_types.balance_type_id%type;
4700:
4701:
4702: begin
4703: --hr_utility.trace_on(null,'ZAEID');

Line 4722: from pay_balance_types

4718: begin
4719:
4720: select balance_type_id
4721: into l_ee_balance_type_id
4722: from pay_balance_types
4723: where balance_name = 'Total Employment Equityable Income'
4724: and legislation_code = 'ZA'
4725: and business_group_id is null;
4726:

Line 4729: from pay_balance_types

4725: and business_group_id is null;
4726:
4727: select balance_type_id
4728: into l_eea_balance_type_id
4729: from pay_balance_types
4730: where balance_name = 'Total Employment Equityable Annual Income'
4731: and legislation_code = 'ZA'
4732: and business_group_id is null;
4733:

Line 4737: from pay_balance_types

4733:
4734: --Changes for Bug 7237663
4735: select balance_type_id
4736: into l_er_balance_type_id
4737: from pay_balance_types
4738: where balance_name = 'Total Employment Equityable ER Normal Contributions'
4739: and legislation_code = 'ZA'
4740: and business_group_id is null;
4741:

Line 4744: from pay_balance_types

4740: and business_group_id is null;
4741:
4742: select balance_type_id
4743: into l_era_balance_type_id
4744: from pay_balance_types
4745: where balance_name = 'Total Employment Equityable ER Annual Contributions'
4746: and legislation_code = 'ZA'
4747: and business_group_id is null;
4748: --End changes for Bug 7237663

Line 6080: l_ee_balance_type_id pay_balance_types.balance_type_id%type;

6076: l_report_end date;
6077: l_report_date date;
6078: l_difference number;
6079: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
6080: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
6081: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
6082: l_input_value_id pay_input_values_f.input_value_id%type;
6083: l_input_value_id2 pay_input_values_f.input_value_id%type;
6084: l_index number;

Line 6081: l_eea_balance_type_id pay_balance_types.balance_type_id%type;

6077: l_report_date date;
6078: l_difference number;
6079: l_period_frequency per_time_period_types.number_per_fiscal_year%type;
6080: l_ee_balance_type_id pay_balance_types.balance_type_id%type;
6081: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
6082: l_input_value_id pay_input_values_f.input_value_id%type;
6083: l_input_value_id2 pay_input_values_f.input_value_id%type;
6084: l_index number;
6085: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';

Line 6091: l_er_balance_type_id pay_balance_types.balance_type_id%type;

6087: l_sex per_all_people_f.sex%type;
6088: --Changes for Bug 7237663
6089: l_er_income number;
6090: l_er_annual_income number;
6091: l_er_balance_type_id pay_balance_types.balance_type_id%type;
6092: l_era_balance_type_id pay_balance_types.balance_type_id%type;
6093: l_type varchar2(5);
6094:
6095:

Line 6092: l_era_balance_type_id pay_balance_types.balance_type_id%type;

6088: --Changes for Bug 7237663
6089: l_er_income number;
6090: l_er_annual_income number;
6091: l_er_balance_type_id pay_balance_types.balance_type_id%type;
6092: l_era_balance_type_id pay_balance_types.balance_type_id%type;
6093: l_type varchar2(5);
6094:
6095:
6096: begin

Line 6116: from pay_balance_types

6112: begin
6113:
6114: select balance_type_id
6115: into l_ee_balance_type_id
6116: from pay_balance_types
6117: where balance_name = 'Total Employment Equityable Income'
6118: and legislation_code = 'ZA'
6119: and business_group_id is null;
6120:

Line 6123: from pay_balance_types

6119: and business_group_id is null;
6120:
6121: select balance_type_id
6122: into l_eea_balance_type_id
6123: from pay_balance_types
6124: where balance_name = 'Total Employment Equityable Annual Income'
6125: and legislation_code = 'ZA'
6126: and business_group_id is null;
6127:

Line 6131: from pay_balance_types

6127:
6128: --Changes for Bug 7237663
6129: select balance_type_id
6130: into l_er_balance_type_id
6131: from pay_balance_types
6132: where balance_name = 'Total Employment Equityable ER Normal Contributions'
6133: and legislation_code = 'ZA'
6134: and business_group_id is null;
6135:

Line 6138: from pay_balance_types

6134: and business_group_id is null;
6135:
6136: select balance_type_id
6137: into l_era_balance_type_id
6138: from pay_balance_types
6139: where balance_name = 'Total Employment Equityable ER Annual Contributions'
6140: and legislation_code = 'ZA'
6141: and business_group_id is null;
6142: --End changes for Bug 7237663