DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1900: FROM pay_element_entry_values_f

1896: -- Bug 3057542 changes for checking future row
1897: --
1898: CURSOR c_exists (p_input_value_id IN NUMBER) IS
1899: SELECT effective_start_date
1900: FROM pay_element_entry_values_f
1901: WHERE element_entry_id = p_element_entry_id
1902: AND input_value_id = p_input_value_id
1903: AND effective_start_date >= p_calculation_date + 1
1904: ORDER by effective_start_date;

Line 1906: l_eff_start_date pay_element_entry_values_f.effective_start_date%TYPE;

1902: AND input_value_id = p_input_value_id
1903: AND effective_start_date >= p_calculation_date + 1
1904: ORDER by effective_start_date;
1905: --
1906: l_eff_start_date pay_element_entry_values_f.effective_start_date%TYPE;
1907:
1908: l_dummy VARCHAR2(10);
1909: l_upd_mode VARCHAR2(30);
1910: --