DBA Data[Home] [Help]

APPS.PER_ES_ABSENCE dependencies on PAY_INPUT_VALUES_F

Line 27: FROM pay_input_values_f pivf

23: CURSOR csr_get_input_value_info(p_element_entry_id NUMBER
24: ,p_input_value_name VARCHAR2
25: ,p_date DATE) IS
26: SELECT pivf.input_value_id iv_start_date_id
27: FROM pay_input_values_f pivf
28: ,pay_element_entries_f peef
29: ,pay_element_types_f petf
30: WHERE peef.element_entry_id = p_element_entry_id
31: AND peef.element_type_id = petf.element_type_id

Line 42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;

38: AND p_date BETWEEN pivf.effective_start_date
39: AND pivf.effective_end_date;
40: --
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

Line 43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;

39: AND pivf.effective_end_date;
40: --
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
47: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

Line 44: l_absence_id pay_input_values_f.input_value_id%TYPE;

40: --
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
47: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
48: l_ovn pay_element_entries_f.object_version_number%TYPE;

Line 45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;

41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
47: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
48: l_ovn pay_element_entries_f.object_version_number%TYPE;
49: l_o_start_dt pay_element_entries_f.effective_start_date%TYPE;

Line 193: FROM pay_input_values_f pivf

189: CURSOR csr_get_input_value_info(p_element_entry_id NUMBER
190: ,p_input_value_name VARCHAR2
191: ,p_date DATE) IS
192: SELECT pivf.input_value_id iv_start_date_id
193: FROM pay_input_values_f pivf
194: ,pay_element_entries_f peef
195: ,pay_element_types_f petf
196: WHERE peef.element_entry_id = p_element_entry_id
197: AND peef.element_type_id = petf.element_type_id

Line 208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;

204: AND p_date BETWEEN pivf.effective_start_date
205: AND pivf.effective_end_date;
206: --
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

Line 209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;

205: AND pivf.effective_end_date;
206: --
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
213: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

Line 210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;

206: --
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
213: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
214: l_ovn pay_element_entries_f.object_version_number%TYPE;

Line 211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;

207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
213: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
214: l_ovn pay_element_entries_f.object_version_number%TYPE;
215: l_o_start_dt pay_element_entries_f.effective_start_date%TYPE;

Line 218: l_bus_grp_id pay_input_values_f.business_group_id%TYPE;

214: l_ovn pay_element_entries_f.object_version_number%TYPE;
215: l_o_start_dt pay_element_entries_f.effective_start_date%TYPE;
216: l_o_end_dt pay_element_entries_f.effective_end_date%TYPE;
217: l_o_warning BOOLEAN;
218: l_bus_grp_id pay_input_values_f.business_group_id%TYPE;
219:
220: --
221: BEGIN
222: --