APPS.HR_NZ_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 38: l_seasonal_shutdown pay_element_entry_values_f.screen_entry_value%type ;

34: ,p_creator_id in number) is
35:
36: l_procedure_name varchar2(61) := 'hr_nz_element_entry_hook.populate_absence_dev_desc_flex' ;
37: l_batch_id per_absence_attendances.batch_id%type ;
38: l_seasonal_shutdown pay_element_entry_values_f.screen_entry_value%type ;
39: l_number_of_complete_weeks pay_element_entry_values_f.screen_entry_value%type ;
40: l_absence_category per_absence_attendance_types.absence_category%type;
41: l_element_name pay_element_types_f.element_name%type;
42:

Line 39: l_number_of_complete_weeks pay_element_entry_values_f.screen_entry_value%type ;

35:
36: l_procedure_name varchar2(61) := 'hr_nz_element_entry_hook.populate_absence_dev_desc_flex' ;
37: l_batch_id per_absence_attendances.batch_id%type ;
38: l_seasonal_shutdown pay_element_entry_values_f.screen_entry_value%type ;
39: l_number_of_complete_weeks pay_element_entry_values_f.screen_entry_value%type ;
40: l_absence_category per_absence_attendance_types.absence_category%type;
41: l_element_name pay_element_types_f.element_name%type;
42:
43: -- cursor to get the batch ID for the absence

Line 55: , pay_element_entry_values_f eev

51: ,p_effective_date date
52: ,p_input_name varchar2) is
53: select eev.screen_entry_value
54: from pay_input_values_f iv
55: , pay_element_entry_values_f eev
56: where eev.element_entry_id = p_element_entry_id
57: and p_effective_date between eev.effective_start_date
58: and eev.effective_end_date
59: and iv.input_value_id = eev.input_value_id