APPS.PAY_FRR_BUS dependencies on PAY_INPUT_VALUES_F

Line 951: l_uom pay_input_values_f.uom%type;

947: ,p_input_value_id in number
948: ) is
949: --
950: l_proc varchar2(72) := g_package||'chk_input_value_id';
951: l_uom pay_input_values_f.uom%type;
952: l_op_datatype ff_fdi_usages_f.data_type%type;
953: --
954: Cursor c_chk_input_value is
955: select uom

Line 956: from pay_input_values_f piv

952: l_op_datatype ff_fdi_usages_f.data_type%type;
953: --
954: Cursor c_chk_input_value is
955: select uom
956: from pay_input_values_f piv
957: where piv.input_value_id = p_input_value_id
958: and piv.element_type_id = p_element_type_id
959: and p_effective_date between piv.effective_start_date
960: and piv.effective_end_date;

Line 990: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');

986: If c_chk_input_value%notfound then
987: Close c_chk_input_value;
988: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
989: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
990: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
991: fnd_message.raise_error;
992: End If;
993: Close c_chk_input_value;
994: --