APPS.PAY_CN_DEDUCTIONS dependencies on PAY_INPUT_VALUES_F

Line 1895: pay_input_values_f piv

1891: CURSOR c_iv IS
1892: SELECT piv.input_value_id
1893: FROM pay_element_entries_f pee,
1894: pay_element_links_f pel,
1895: pay_input_values_f piv
1896: WHERE pee.element_entry_id = p_element_entry_id
1897: AND pee.element_link_id = pel.element_link_id
1898: AND pel.element_type_id = piv.element_type_id
1899: AND piv.name = 'Calculation Date'

Line 1904: l_iv_id pay_input_values_f.input_value_id%TYPE;

1900: AND p_calculation_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1901: AND p_calculation_date BETWEEN pel.effective_start_date AND pel.effective_end_date
1902: AND p_calculation_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
1903: --
1904: l_iv_id pay_input_values_f.input_value_id%TYPE;
1905: --
1906: -- Bug 3057542 changes for checking future row
1907: --
1908: CURSOR c_exists (p_input_value_id IN NUMBER) IS