DBA Data[Home] [Help]

APPS.HR_AU_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 42: l_element_name pay_element_types_f.element_name%type;

38: l_batch_id per_absence_attendances.batch_id%type ;
39: l_certificate_required pay_element_entry_values_f.screen_entry_value%type ;
40: l_certificate_received pay_element_entry_values_f.screen_entry_value%type ;
41: l_absence_category per_absence_attendance_types.absence_category%type;
42: l_element_name pay_element_types_f.element_name%type;
43:
44: -- cursor to get the batch ID for the absence
45:
46: cursor c_absence (p_absence_attendance_id number)

Line 77: ,pay_element_types_f pet

73: select paa.absence_category,
74: element_name
75: from pay_element_entries_f pee
76: ,pay_element_links_f pef
77: ,pay_element_types_f pet
78: ,pay_input_values_F piv
79: ,per_absence_attendance_types paa
80: where pee.element_link_id = pef.element_link_id
81: and pef.element_type_id = pet.element_type_id