DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on JTF_RS_SALESREPS

Line 7411: ,JTF_RS_SALESREPS S

7407: ,TL.RESOURCE_NAME CONTACT_NAME
7408: ,PR.ID CONTACT_ROLE_ID
7409: ,CO.CRO_CODE CONTACT_ROLE_CODE
7410: FROM JTF_RS_RESOURCE_EXTNS CS
7411: ,JTF_RS_SALESREPS S
7412: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7413: ,OKC_CONTACTS CO
7414: ,OKC_K_PARTY_ROLES_B PR
7415: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

Line 7496: ,JTF_RS_SALESREPS S

7492: ,TL.RESOURCE_NAME CONTACT_NAME -- Bug Fix #5442182 hmnair
7493: ,PR.ID CONTACT_ROLE_ID
7494: ,CO.CRO_CODE CONTACT_ROLE_CODE
7495: FROM JTF_RS_RESOURCE_EXTNS CS
7496: ,JTF_RS_SALESREPS S
7497: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7498: ,OKC_CONTACTS CO
7499: ,OKC_K_PARTY_ROLES_B PR
7500: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

Line 7572: JTF_RS_SALESREPS SRP

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
7576: AND U.USER_ID = RSC.USER_ID