DBA Data[Home] [Help]

APPS.HR_NZ_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 41: l_element_name pay_element_types_f.element_name%type;

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
44: cursor c_absence (p_absence_attendance_id number) is
45: select aa.batch_id

Line 73: , pay_element_types_f pet

69: element_name
70: from
71: pay_element_entries_f pee
72: , pay_element_links_f pef
73: , pay_element_types_f pet
74: , pay_input_values_F piv
75: , per_absence_attendance_types paa
76: where pee.element_link_id= pef.element_link_id
77: and pef.element_type_id = pet.element_type_id