DBA Data[Home] [Help]

APPS.OKS_MASSCHANGE_PVT dependencies on FND_USER

Line 6766: fnd_user usr

6762:
6763: CURSOR get_oie_name IS
6764: SELECT name, usr.user_name
6765: FROM okc_operation_instances_v oie,
6766: fnd_user usr
6767: WHERE id = p_oie_id
6768: AND oie.last_updated_by = usr.user_id;
6769: l_errbuf VARCHAR2(200);
6770: l_retcode NUMBER;

Line 13322: ,FND_USER U

13318: -- Select statemet for the following cursor was changed to address performance issue. Bug#3231915
13319: CURSOR get_pref_engg(p_attr_code IN Varchar2) IS
13320: SELECT EMP.FULL_NAME NAME
13321: FROM JTF_RS_RESOURCE_EXTNS RSC
13322: ,FND_USER U
13323: ,OKX_PER_ALL_PEOPLE_V EMP
13324: WHERE RSC.RESOURCE_ID = p_attr_code
13325: AND RSC.CATEGORY = 'EMPLOYEE'
13326: AND EMP.PERSON_ID = RSC.SOURCE_ID