DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on JTF_RS_SALESREPS

Line 7023: ,JTF_RS_SALESREPS S

7019: ,TL.RESOURCE_NAME CONTACT_NAME
7020: ,PR.ID CONTACT_ROLE_ID
7021: ,CO.CRO_CODE CONTACT_ROLE_CODE
7022: FROM JTF_RS_RESOURCE_EXTNS CS
7023: ,JTF_RS_SALESREPS S
7024: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7025: ,OKC_CONTACTS CO
7026: ,OKC_K_PARTY_ROLES_B PR
7027: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

Line 7108: ,JTF_RS_SALESREPS S

7104: ,TL.RESOURCE_NAME CONTACT_NAME -- Bug Fix #5442182 hmnair
7105: ,PR.ID CONTACT_ROLE_ID
7106: ,CO.CRO_CODE CONTACT_ROLE_CODE
7107: FROM JTF_RS_RESOURCE_EXTNS CS
7108: ,JTF_RS_SALESREPS S
7109: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7110: ,OKC_CONTACTS CO
7111: ,OKC_K_PARTY_ROLES_B PR
7112: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

Line 7184: JTF_RS_SALESREPS SRP

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