APPS.PAY_FRR_BUS dependencies on PAY_INPUT_VALUES_F

Line 932: l_uom pay_input_values_f.uom%type;

928: ,p_input_value_id in number
929: ) is
930: --
931: l_proc varchar2(72) := g_package||'chk_input_value_id';
932: l_uom pay_input_values_f.uom%type;
933: l_op_datatype ff_fdi_usages_f.data_type%type;
934: --
935: Cursor c_chk_input_value is
936: select uom

Line 937: from pay_input_values_f piv

933: l_op_datatype ff_fdi_usages_f.data_type%type;
934: --
935: Cursor c_chk_input_value is
936: select uom
937: from pay_input_values_f piv
938: where piv.input_value_id = p_input_value_id
939: and piv.element_type_id = p_element_type_id
940: and p_effective_date between piv.effective_start_date
941: and piv.effective_end_date;

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

967: If c_chk_input_value%notfound then
968: Close c_chk_input_value;
969: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
970: fnd_message.set_token('COLUMN','INPUT_VALUE_ID');
971: fnd_message.set_token('TABLE','PAY_INPUT_VALUES_F');
972: fnd_message.raise_error;
973: End If;
974: Close c_chk_input_value;
975: --