APPS.PAY_INPUT_VALUE_API dependencies on PAY_INPUT_VALUES_F

Line 124: l_business_group_id pay_input_values_f.business_group_id%type;

120: where element_type_id = p_element_type_id;
121:
122: --
123:
124: l_business_group_id pay_input_values_f.business_group_id%type;
125: l_legislation_code pay_input_values_f.legislation_code%type;
126: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
127:
128:

Line 125: l_legislation_code pay_input_values_f.legislation_code%type;

121:
122: --
123:
124: l_business_group_id pay_input_values_f.business_group_id%type;
125: l_legislation_code pay_input_values_f.legislation_code%type;
126: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
127:
128:
129: l_proc varchar2(72) := g_package||'CREATE_INPUT_VALUE';

Line 126: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;

122: --
123:
124: l_business_group_id pay_input_values_f.business_group_id%type;
125: l_legislation_code pay_input_values_f.legislation_code%type;
126: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
127:
128:
129: l_proc varchar2(72) := g_package||'CREATE_INPUT_VALUE';
130: begin

Line 357: from pay_input_values_f

353: --
354: cursor csr_derived_values
355: is
356: select business_group_id,legislation_code,element_type_id,legislation_subgroup
357: from pay_input_values_f
358: where input_value_id = p_input_value_id;
359:
360:
361: l_element_type_id pay_input_values_f.element_type_id%type;

Line 361: l_element_type_id pay_input_values_f.element_type_id%type;

357: from pay_input_values_f
358: where input_value_id = p_input_value_id;
359:
360:
361: l_element_type_id pay_input_values_f.element_type_id%type;
362: l_business_group_id pay_input_values_f.business_group_id%type;
363: l_legislation_code pay_input_values_f.legislation_code%type;
364: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
365:

Line 362: l_business_group_id pay_input_values_f.business_group_id%type;

358: where input_value_id = p_input_value_id;
359:
360:
361: l_element_type_id pay_input_values_f.element_type_id%type;
362: l_business_group_id pay_input_values_f.business_group_id%type;
363: l_legislation_code pay_input_values_f.legislation_code%type;
364: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
365:
366: l_proc varchar2(72) := g_package||'UPDATE_INPUT_VALUE';

Line 363: l_legislation_code pay_input_values_f.legislation_code%type;

359:
360:
361: l_element_type_id pay_input_values_f.element_type_id%type;
362: l_business_group_id pay_input_values_f.business_group_id%type;
363: l_legislation_code pay_input_values_f.legislation_code%type;
364: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
365:
366: l_proc varchar2(72) := g_package||'UPDATE_INPUT_VALUE';
367: begin

Line 364: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;

360:
361: l_element_type_id pay_input_values_f.element_type_id%type;
362: l_business_group_id pay_input_values_f.business_group_id%type;
363: l_legislation_code pay_input_values_f.legislation_code%type;
364: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
365:
366: l_proc varchar2(72) := g_package||'UPDATE_INPUT_VALUE';
367: begin
368: hr_utility.set_location('Entering:'|| l_proc, 10);