DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on PER_ALL_PEOPLE_F

Line 50: per_all_people_f emp

46: SELECT emp.full_name NAME,
47: emp.work_telephone phone,
48: emp.email_address email
49: FROM jtf_rs_resource_extns rsc,
50: per_all_people_f emp
51: WHERE rsc.CATEGORY = 'EMPLOYEE'
52: AND emp.person_id = rsc.source_id
53: AND rsc.resource_id = TO_NUMBER (p_object1_id1)
54: AND '#' = p_object1_id2

Line 103: PER_ALL_PEOPLE_F EMP

99: AND '#' = p_object1_id2
100: UNION ALL
101: SELECT EMP.FULL_NAME name , emp.work_telephone phone ,emp.email_address email
102: FROM JTF_RS_RESOURCE_EXTNS RSC ,
103: PER_ALL_PEOPLE_F EMP
104: WHERE
105: RSC.CATEGORY = 'EMPLOYEE'
106: AND EMP.PERSON_ID = RSC.SOURCE_ID
107: AND RSC.RESOURCE_ID = to_number(p_object1_id1)