APPS.OKS_ENTITLEMENTS_WEB dependencies on JTF_RS_SALESREPS

Line 1876: ,JTF_RS_SALESREPS SRP

1872: SELECT /*+ ordered */
1873: TL.RESOURCE_NAME name
1874: FROM
1875: JTF_RS_RESOURCE_EXTNS RSC
1876: ,JTF_RS_SALESREPS SRP
1877: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182
1878: ,FND_USER U
1879:
1880: WHERE

Line 1897: FROM JTF_RS_SALESREPS S

1893: Select name From OKX_PARTY_CONTACTS_V Where id1 = to_number(p_object1_id1) and id2 = p_object1_id2;
1894: CURSOR party_contact_name_cur3(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2)
1895: IS
1896: SELECT TL.RESOURCE_NAME
1897: FROM JTF_RS_SALESREPS S
1898: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182
1899: WHERE S.salesrep_id = TO_NUMBER(p_object1_id1)
1900: AND S.org_id = p_org_id
1901: AND S.RESOURCE_ID = TL.RESOURCE_ID

Line 2019: FROM JTF_RS_SALESREPS

2015: WHERE id = contract_id;
2016:
2017: CURSOR salesrep_email_cur(p_org_id NUMBER,p_contact_id VARCHAR2) IS
2018: SELECT email_address
2019: FROM JTF_RS_SALESREPS
2020: WHERE salesrep_id = p_contact_id
2021: AND org_id = p_org_id;
2022:
2023: CURSOR resource_email_cur(p_contact_id VARCHAR2) IS

Line 3301: JTF_RS_SALESREPS SRP

3297: okc_contacts_v con,
3298: okc_k_party_roles_b pty ,
3299: JTF_RS_RESOURCE_EXTNS RSC ,
3300: FND_USER U ,
3301: JTF_RS_SALESREPS SRP
3302: where
3303: pty.cle_id = to_number(p_bus_proc_ID_arg)
3304: and pty.dnz_chr_id = to_number(p_contract_ID_arg)
3305: and con.cpl_id = pty.id