DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on FND_USER

Line 1850: FND_USER U ,

1846: UNION ALL
1847: SELECT
1848: EMP.FULL_NAME name
1849: FROM JTF_RS_RESOURCE_EXTNS RSC ,
1850: FND_USER U ,
1851: OKX_PER_ALL_PEOPLE_V EMP
1852: WHERE
1853: RSC.CATEGORY = 'EMPLOYEE'
1854: AND EMP.PERSON_ID = RSC.SOURCE_ID

Line 1863: FND_USER U ,

1859: SELECT
1860: PARTY.PARTY_NAME name
1861: FROM
1862: JTF_RS_RESOURCE_EXTNS RSC ,
1863: FND_USER U ,
1864: HZ_PARTIES PARTY
1865: WHERE
1866: RSC.CATEGORY IN ( 'PARTY', 'PARTNER')
1867: AND PARTY.PARTY_ID = RSC.SOURCE_ID

Line 1878: ,FND_USER U

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
1881: RSC.CATEGORY = 'OTHER'
1882: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID

Line 3256: FND_USER U ,

3252: from
3253: okc_contacts_v con,
3254: okc_k_party_roles_b pty ,
3255: JTF_RS_RESOURCE_EXTNS RSC ,
3256: FND_USER U ,
3257: OKX_PER_ALL_PEOPLE_V EMP
3258: where
3259: pty.cle_id = to_number(p_bus_proc_ID_arg)
3260: and pty.dnz_chr_id = to_number(p_contract_ID_arg)

Line 3278: FND_USER U ,

3274: from
3275: okc_contacts_v con,
3276: okc_k_party_roles_b pty ,
3277: JTF_RS_RESOURCE_EXTNS RSC ,
3278: FND_USER U ,
3279: HZ_PARTIES PARTY
3280: where
3281: pty.cle_id = to_number(p_bus_proc_ID_arg)
3282: and pty.dnz_chr_id = to_number(p_contract_ID_arg)

Line 3300: FND_USER U ,

3296: from
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)