APPS.PAY_CN_DEDUCTIONS dependencies on PAY_INPUT_VALUES_F

Line 1885: pay_input_values_f piv

1881: CURSOR c_iv IS
1882: SELECT piv.input_value_id
1883: FROM pay_element_entries_f pee,
1884: pay_element_links_f pel,
1885: pay_input_values_f piv
1886: WHERE pee.element_entry_id = p_element_entry_id
1887: AND pee.element_link_id = pel.element_link_id
1888: AND pel.element_type_id = piv.element_type_id
1889: AND piv.name = 'Calculation Date'

Line 1894: l_iv_id pay_input_values_f.input_value_id%TYPE;

1890: AND p_calculation_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1891: AND p_calculation_date BETWEEN pel.effective_start_date AND pel.effective_end_date
1892: AND p_calculation_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
1893: --
1894: l_iv_id pay_input_values_f.input_value_id%TYPE;
1895: --
1896: -- Bug 3057542 changes for checking future row
1897: --
1898: CURSOR c_exists (p_input_value_id IN NUMBER) IS