eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_ENTITLEMENTS_PVT dependencies on FND_USER

Line 7545: FND_USER U ,

7541:
7542: CURSOR Lx_Csr_emp_name(Cx_Resource_Id IN number) IS
7543: SELECT PER.FULL_NAME NAME
7544: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7545: FND_USER U ,
7546: PER_ALL_PEOPLE_F PER
7547: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7548: and U.USER_ID = RSC.USER_ID
7549: and RSC.RESOURCE_ID = Cx_Resource_Id

Line 7558: FND_USER U ,

7554:
7555: CURSOR Lx_Csr_pty_name(Cx_Resource_Id IN number) IS
7556: SELECT PARTY.PARTY_NAME NAME
7557: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7558: FND_USER U ,
7559: HZ_PARTIES PARTY
7560: WHERE RSC.CATEGORY IN ( 'PARTNER', 'PARTY')
7561: AND PARTY.PARTY_ID = RSC.SOURCE_ID
7562: AND U.USER_ID = RSC.USER_ID

Line 7571: FND_USER U ,

7567:
7568: CURSOR Lx_Csr_oth_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7569: SELECT TL.RESOURCE_NAME NAME -- Bug Fix #5442182 hmnair
7570: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7571: FND_USER U ,
7572: JTF_RS_SALESREPS SRP
7573: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7574: WHERE RSC.CATEGORY = 'OTHER'
7575: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID