DBA Data[Home] [Help]

APPS.PAY_DK_SICKPAY_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 45: ,pay_element_entry_values_f eev

41: ,pay_element_links_f el
42: ,pay_element_types_f et
43: ,pay_input_values_f iv
44: ,pay_element_entries_f ee
45: ,pay_element_entry_values_f eev
46: WHERE asg.assignment_id = p_assignment_id
47: AND per.person_id = asg.person_id
48: AND et.element_name IN ('Absent Sick','Absent Holiday')
49: AND et.legislation_code = 'DK'

Line 190: ,pay_element_entry_values_f eev1

186: ,pay_element_links_f el
187: ,pay_element_types_f et
188: ,pay_input_values_f iv1
189: ,pay_element_entries_f ee
190: ,pay_element_entry_values_f eev1
191: WHERE asg1.assignment_id = p_assignment_id
192: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
193: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
194: AND per.person_id = asg1.person_id

Line 213: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

209: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
210: ORDER BY ee.element_entry_id, DECODE(iv1.name, 'Start Date', 1,'End Date', 2, 'Sick Days', 3,'Start Time', 4,'End Time', 5,'Sick Hours', 6) ;
211: --
212: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
213: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
214: eename pay_input_values_f.name%TYPE );
215: l_rec l_record;
216: TYPE l_table is table of l_record index by BINARY_INTEGER;
217: l_tab l_table;

Line 227: l_start_time pay_element_entry_values_f.screen_entry_value%TYPE;

223: l_counter number ;
224: l_bool_match boolean;
225: l_num_match number;
226: /*Bug 5047360 fix */
227: l_start_time pay_element_entry_values_f.screen_entry_value%TYPE;
228: l_end_time pay_element_entry_values_f.screen_entry_value%TYPE;
229: --
230: BEGIN
231: --

Line 228: l_end_time pay_element_entry_values_f.screen_entry_value%TYPE;

224: l_bool_match boolean;
225: l_num_match number;
226: /*Bug 5047360 fix */
227: l_start_time pay_element_entry_values_f.screen_entry_value%TYPE;
228: l_end_time pay_element_entry_values_f.screen_entry_value%TYPE;
229: --
230: BEGIN
231: --
232: l_counter := 1;

Line 406: ,pay_element_entry_values_f eev

402: ,pay_element_links_f el
403: ,pay_element_types_f et
404: ,pay_input_values_f iv
405: ,pay_element_entries_f ee
406: ,pay_element_entry_values_f eev
407: WHERE asg.assignment_id = p_assignment_id
408: AND per.person_id = asg.person_id
409: AND et.element_name IN ('Absent Sick','Absent Holiday')
410: AND et.legislation_code = 'DK'