How to get Employee Supervisor Hierarchy?

I was recently asked this question.
The following script finds the Employee Supervisor Hierarchy:

SELECT paf.person_id, paf.supervisor_id
, LPAD (' ', 2 * LEVEL - 1)
|| SYS_CONNECT_BY_PATH (paf.person_id, '/') PATH
, LEVEL, paf.job_id -- used for linking to hr.per_jobs ,
, paf.effective_start_date, paf.effective_end_date
FROM per_all_assignments_f paf
START WITH paf.person_id = <:person_id>
AND paf.primary_flag = 'Y'
AND paf.assignment_type = 'E'
AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date
AND assignment_status_type_id = 1
CONNECT BY PRIOR paf.person_id = paf.supervisor_id
AND paf.primary_flag = 'Y'
AND paf.assignment_type = 'E'
AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date
AND assignment_status_type_id = 1

Note: In order to find the Person_id, select Person_id, Last_name, First_name from Per_all_people_f
The above sql will find topdown (Highest Level and follows down)
If you want to start from the lowest level and go all the way to CEO, then change the CONNECT BY clause as mentioned below:
CONNECT BY PRIOR paf.supervisor_id = paf.person_id

How to Capture invalid email address?

How can invalid or mal-formed email address (or so called bouncing emails) be captured?

As note: 456378.1 says, after enabling the event WF_MAIL.Disable_Recipient_Ntf_Pref, if a recipient's email address is invalid, an email notification is sent out the SYSADMIN that an email notification could not be sent.
Note:
1. However, this will work only on or after RUP5.
2. Notification preference for SYSADMIN should be MAILHTML or MAIL

to read the complete metalink note, click here

How To Find Out What Time A Timecard Was Submitted Using Wfstatus.sql

I was recently posed a question: To identify when a timecard was submited?
Easy: Use WFSTATUS.sql
Pass parameters the Internal Type of the Timecard and the Timecard Number (It is also the Expenditure_ID as well as the Item Key)
Reference: Metalink Note: 185820.1

Macroscope

I find Macroscope pretty useful tool in providing complete picture of the documentation - Easy to use, many quick links to navigate both horizontally and vertically within the product, it is a pleasant experience. Based on PMP Methodolgy. At a very high level, Macroscope documents are created based on Owner's view, User's view and Developer's View. To know more about Macroscope Click here
I saw a pdf which provides more information on this,
Click here to read more about it.

It is interesting to note that Macroscope is considered as a as a Market leader by Gartner as shown in the picture below:

More on this latter.

How to display images in a seperate lines?

Pix 1:

I was trying to get two images displayed on a separate lines - although these are adjacent to each other; however to my exasperation, the images were displayed on the same lines. Have tried various tricks, including

. It is not consistent. For example these photos had to manually separated using text like this. Whereas, I was able to separate the technorati and LinkedIn icons. I will try to look at some examples later.
On a side note, these are the pictures of a bird that appeared outside our home, after I placed a toy bird - looks exactly like the one in the photo.

Pix 2: