APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_INPUT_VALUES_F

Line 271: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;

267: p_errbuff OUT nocopy VARCHAR2)
268:
269: IS
270: -- IN variables
271: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
272: l_name PER_PAY_BASES.NAME%TYPE := p_name;
273: l_pay_basis_name PER_PAY_BASES.PAY_BASIS%TYPE := p_pay_basis_name;
274: l_rate_id PAY_RATES.RATE_ID%TYPE;
275: l_pay_annualization_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE := p_pay_annualization_factor;

Line 287: FROM PAY_INPUT_VALUES_F i,PAY_ELEMENT_TYPES_F e

283:
284: -- Declare a cursor to capture input value id
285: CURSOR csr_input_value_id IS
286: SELECT i.input_value_id
287: FROM PAY_INPUT_VALUES_F i,PAY_ELEMENT_TYPES_F e
288: WHERE i.element_type_id = e.element_type_id
289: AND i.name = p_input_value_name
290: AND e.element_name = p_element_name
291: AND e.legislation_code = p_legislation_code; -- CHANGE THE LEGISLATION CODE ACCORDING TO REQUIREMENT