APPS.PER_BBT_BUS dependencies on PAY_INPUT_VALUES_F

Line 216: -- ensure that the value exists in PAY_INPUT_VALUES_F for a input value

212: --
213: -- Description:
214: -- This procedure checks to ensure :
215: -- a) If the column INPUT_VALUE_ID is not null, then a check will be made to
216: -- ensure that the value exists in PAY_INPUT_VALUES_F for a input value
217: -- of the same business group.
218: -- b) If the INPUT_VALUE_ID is not null, and the UOM column is not null, then
219: -- a check will be made to ensure that the UOM is the same as the UOM on
220: -- PAY_INPUT_VALUES_F.

Line 220: -- PAY_INPUT_VALUES_F.

216: -- ensure that the value exists in PAY_INPUT_VALUES_F for a input value
217: -- of the same business group.
218: -- b) If the INPUT_VALUE_ID is not null, and the UOM column is not null, then
219: -- a check will be made to ensure that the UOM is the same as the UOM on
220: -- PAY_INPUT_VALUES_F.
221: -- c) If INPUT_VALUE_ID is not null, and CURRENCY is not null, a check will
222: -- be made to ensure that the output_currency_code on the Element Type
223: -- for the input value is the same.
224: --

Line 260: , pay_input_values_f iv

256: ,iv.effective_end_date
257: ,et.output_currency_code
258: ,iv.uom
259: FROM pay_element_types_f et
260: , pay_input_values_f iv
261: WHERE iv.input_value_id = p_input_value_id
262: AND iv.element_type_id= et.element_type_id
263: AND iv.business_group_id = p_business_group_id;
264: --

Line 295: -- PAY_INPUT_VALUES_F in the same bg so error.

291: --
292: CLOSE csr_get_input_details;
293: --
294: -- The input_value_id that is being entered isn't in the table
295: -- PAY_INPUT_VALUES_F in the same bg so error.
296: --
297: hr_utility.set_message (800,'HR_52939_INVALID_INPUT_ID');
298: hr_utility.raise_error;
299: --