Retrieve leave info
Hi,
I use the following query to retrieve leave application of employees under a particular manager. But even though i enter replacement person, leave days etc, some of these fields are not populated at all. Is this data stored in some other table? How can i retrieve the projected leave dates and the name of the person replacement?
select hat.TRANSACTION_REF_ID absence_attendance_id, hat.item_key,p.person_id,p.employee_number,
decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',p.global_name,p.local_name) full_name,
to_number(hats.Information5) absence_attendance_type_id ,
I use the following query to retrieve leave application of employees under a particular manager. But even though i enter replacement person, leave days etc, some of these fields are not populated at all. Is this data stored in some other table? How can i retrieve the projected leave dates and the name of the person replacement?
select hat.TRANSACTION_REF_ID absence_attendance_id, hat.item_key,p.person_id,p.employee_number,
decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',p.global_name,p.local_name) full_name,
to_number(hats.Information5) absence_attendance_type_id ,
Tagged:
0