DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 7024: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair

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)
7028: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7109: ,JTF_RS_RESOURCE_EXTNS_TL TL -- 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)
7113: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7185: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair

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
7189: AND SRP.Org_ID = Cn_Org_Id -- Modified for 12.0 MOAC project (JVARGHES)