Unale to fetch data from other table in EBS

Hi All.

Please find the eference document  link http://docs.oracle.com/cd/E11223_01/doc.910/e11202/intro.htm#BABBIFGA where i try to fetch data fom different table .

I have created a new table in EBS called XXHR_OPCO and grant privilages have been given.

S now i have to fecth all details from

PER_ALL_PEOPLE_F
PER_PERSON_TYPES
PER_PERSON_TYPE_USAGES_F
PER_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_JOBS
PER_GRADES
HR_ALL_ORGANIZATION_UNITS
AND OPCO details from  "XXHR_OPCO"

OPCO attibute has been created and mapped according to the steps provided in the  documentation.