eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_ENTITLEMENTS_PVT dependencies on PER_ALL_PEOPLE_F

Line 7388: ,PER_ALL_PEOPLE_F PER

7384: ,PER.FULL_NAME CONTACT_NAME
7385: ,PR.ID CONTACT_ROLE_ID
7386: ,CO.CRO_CODE CONTACT_ROLE_CODE
7387: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7388: ,PER_ALL_PEOPLE_F PER
7389: ,OKC_CONTACTS CO
7390: ,OKC_K_PARTY_ROLES_B PR
7391: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7392: and co.dnz_chr_id = pr.dnz_chr_id

Line 7398: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A

7394: AND CO.OBJECT1_ID1 = POA.AGENT_ID --CS.ID1
7395: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7396: AND CO.JTOT_OBJECT1_CODE = 'OKX_BUYER'
7397: and POA.AGENT_ID = PER.PERSON_ID
7398: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A
7399: WHERE A.PERSON_ID = PER.PERSON_ID);
7400:
7401: -- getting sales persons based contacts for contract id.
7402:

Line 7471: ,PER_ALL_PEOPLE_F PER

7467: ,PER.FULL_NAME CONTACT_NAME
7468: ,PR.ID CONTACT_ROLE_ID
7469: ,CO.CRO_CODE CONTACT_ROLE_CODE
7470: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7471: ,PER_ALL_PEOPLE_F PER
7472: ,OKC_CONTACTS CO
7473: ,OKC_K_PARTY_ROLES_B PR
7474: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7475: and PR.CLE_ID = Cx_Cle_Id

Line 7482: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A

7478: AND CO.OBJECT1_ID1 = POA.AGENT_ID --CS.ID1
7479: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7480: AND CO.JTOT_OBJECT1_CODE = 'OKX_BUYER'
7481: and POA.AGENT_ID = PER.PERSON_ID
7482: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A
7483: WHERE A.PERSON_ID = PER.PERSON_ID);
7484:
7485:
7486: -- getting sales persons based contacts for contract line id.

Line 7546: PER_ALL_PEOPLE_F PER

7542: CURSOR Lx_Csr_emp_name(Cx_Resource_Id IN number) IS
7543: SELECT PER.FULL_NAME NAME
7544: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7545: FND_USER U ,
7546: PER_ALL_PEOPLE_F PER
7547: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7548: and U.USER_ID = RSC.USER_ID
7549: and RSC.RESOURCE_ID = Cx_Resource_Id
7550: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A

Line 7550: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A

7546: PER_ALL_PEOPLE_F PER
7547: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7548: and U.USER_ID = RSC.USER_ID
7549: and RSC.RESOURCE_ID = Cx_Resource_Id
7550: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A
7551: WHERE A.PERSON_ID = PER.PERSON_ID);
7552:
7553: -- for category 'PARTNER', 'PARTY'
7554: