APPS.PAY_INPUT_VALUE_API dependencies on PAY_INPUT_VALUES_F

Line 51: l_business_group_id pay_input_values_f.business_group_id%type;

47: from pay_element_types_f
48: where element_type_id = p_element_type_id;
49:
50:
51: l_business_group_id pay_input_values_f.business_group_id%type;
52: l_legislation_code pay_input_values_f.legislation_code%type;
53: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
54:
55:

Line 52: l_legislation_code pay_input_values_f.legislation_code%type;

48: where element_type_id = p_element_type_id;
49:
50:
51: l_business_group_id pay_input_values_f.business_group_id%type;
52: l_legislation_code pay_input_values_f.legislation_code%type;
53: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
54:
55:
56: l_proc varchar2(72) := g_package||'CREATE_INPUT_VALUE';

Line 53: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;

49:
50:
51: l_business_group_id pay_input_values_f.business_group_id%type;
52: l_legislation_code pay_input_values_f.legislation_code%type;
53: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
54:
55:
56: l_proc varchar2(72) := g_package||'CREATE_INPUT_VALUE';
57: begin

Line 265: from pay_input_values_f

261: --
262: cursor csr_derived_values
263: is
264: select business_group_id,legislation_code,element_type_id,legislation_subgroup
265: from pay_input_values_f
266: where input_value_id = p_input_value_id;
267:
268:
269: l_element_type_id pay_input_values_f.element_type_id%type;

Line 269: l_element_type_id pay_input_values_f.element_type_id%type;

265: from pay_input_values_f
266: where input_value_id = p_input_value_id;
267:
268:
269: l_element_type_id pay_input_values_f.element_type_id%type;
270: l_business_group_id pay_input_values_f.business_group_id%type;
271: l_legislation_code pay_input_values_f.legislation_code%type;
272: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
273:

Line 270: l_business_group_id pay_input_values_f.business_group_id%type;

266: where input_value_id = p_input_value_id;
267:
268:
269: l_element_type_id pay_input_values_f.element_type_id%type;
270: l_business_group_id pay_input_values_f.business_group_id%type;
271: l_legislation_code pay_input_values_f.legislation_code%type;
272: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
273:
274: l_proc varchar2(72) := g_package||'UPDATE_INPUT_VALUE';

Line 271: l_legislation_code pay_input_values_f.legislation_code%type;

267:
268:
269: l_element_type_id pay_input_values_f.element_type_id%type;
270: l_business_group_id pay_input_values_f.business_group_id%type;
271: l_legislation_code pay_input_values_f.legislation_code%type;
272: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
273:
274: l_proc varchar2(72) := g_package||'UPDATE_INPUT_VALUE';
275: begin

Line 272: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;

268:
269: l_element_type_id pay_input_values_f.element_type_id%type;
270: l_business_group_id pay_input_values_f.business_group_id%type;
271: l_legislation_code pay_input_values_f.legislation_code%type;
272: l_legislation_subgroup pay_input_values_f.legislation_subgroup%type;
273:
274: l_proc varchar2(72) := g_package||'UPDATE_INPUT_VALUE';
275: begin
276: hr_utility.set_location('Entering:'|| l_proc, 10);