DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1910: FROM pay_element_entry_values_f

1906: -- Bug 3057542 changes for checking future row
1907: --
1908: CURSOR c_exists (p_input_value_id IN NUMBER) IS
1909: SELECT effective_start_date
1910: FROM pay_element_entry_values_f
1911: WHERE element_entry_id = p_element_entry_id
1912: AND input_value_id = p_input_value_id
1913: AND effective_start_date >= p_calculation_date + 1
1914: ORDER by effective_start_date;

Line 1916: l_eff_start_date pay_element_entry_values_f.effective_start_date%TYPE;

1912: AND input_value_id = p_input_value_id
1913: AND effective_start_date >= p_calculation_date + 1
1914: ORDER by effective_start_date;
1915: --
1916: l_eff_start_date pay_element_entry_values_f.effective_start_date%TYPE;
1917:
1918: l_dummy VARCHAR2(10);
1919: l_upd_mode VARCHAR2(30);
1920: --