APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_INPUT_VALUES_F

Line 698: l_input_value_id pay_input_values_f.input_value_id%type;

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
702:

Line 749: from pay_input_values_f pivf,

745: begin
746:
747: select pivf.input_value_id
748: into l_input_value_id
749: from pay_input_values_f pivf,
750: pay_element_types_f petf
751: where petf.element_name = 'ZA Employment Equity Remuneration'
752: and petf.business_group_id is null
753: and petf.legislation_code = 'ZA'

Line 4568: l_input_value_id pay_input_values_f.input_value_id%type;

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
4572: l_sex per_all_people_f.sex%type;

Line 4643: from pay_input_values_f pivf,

4639: begin
4640:
4641: select pivf.input_value_id
4642: into l_input_value_id
4643: from pay_input_values_f pivf,
4644: pay_element_types_f petf
4645: where petf.element_name = 'ZA Employment Equity Remuneration'
4646: and petf.business_group_id is null
4647: and petf.legislation_code = 'ZA'