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 7157: FND_USER U ,

7153:
7154: CURSOR Lx_Csr_emp_name(Cx_Resource_Id IN number) IS
7155: SELECT PER.FULL_NAME NAME
7156: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7157: FND_USER U ,
7158: PER_ALL_PEOPLE_F PER
7159: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7160: and U.USER_ID = RSC.USER_ID
7161: and RSC.RESOURCE_ID = Cx_Resource_Id

Line 7170: FND_USER U ,

7166:
7167: CURSOR Lx_Csr_pty_name(Cx_Resource_Id IN number) IS
7168: SELECT PARTY.PARTY_NAME NAME
7169: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7170: FND_USER U ,
7171: HZ_PARTIES PARTY
7172: WHERE RSC.CATEGORY IN ( 'PARTNER', 'PARTY')
7173: AND PARTY.PARTY_ID = RSC.SOURCE_ID
7174: AND U.USER_ID = RSC.USER_ID

Line 7183: FND_USER U ,

7179:
7180: CURSOR Lx_Csr_oth_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7181: SELECT TL.RESOURCE_NAME NAME -- Bug Fix #5442182 hmnair
7182: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7183: FND_USER U ,
7184: JTF_RS_SALESREPS SRP
7185: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7186: WHERE RSC.CATEGORY = 'OTHER'
7187: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID