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 7000: ,PER_ALL_PEOPLE_F PER

6996: ,PER.FULL_NAME CONTACT_NAME
6997: ,PR.ID CONTACT_ROLE_ID
6998: ,CO.CRO_CODE CONTACT_ROLE_CODE
6999: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7000: ,PER_ALL_PEOPLE_F PER
7001: ,OKC_CONTACTS CO
7002: ,OKC_K_PARTY_ROLES_B PR
7003: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7004: and co.dnz_chr_id = pr.dnz_chr_id

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

7006: AND CO.OBJECT1_ID1 = POA.AGENT_ID --CS.ID1
7007: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7008: AND CO.JTOT_OBJECT1_CODE = 'OKX_BUYER'
7009: and POA.AGENT_ID = PER.PERSON_ID
7010: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A
7011: WHERE A.PERSON_ID = PER.PERSON_ID);
7012:
7013: -- getting sales persons based contacts for contract id.
7014:

Line 7083: ,PER_ALL_PEOPLE_F PER

7079: ,PER.FULL_NAME CONTACT_NAME
7080: ,PR.ID CONTACT_ROLE_ID
7081: ,CO.CRO_CODE CONTACT_ROLE_CODE
7082: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7083: ,PER_ALL_PEOPLE_F PER
7084: ,OKC_CONTACTS CO
7085: ,OKC_K_PARTY_ROLES_B PR
7086: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7087: and PR.CLE_ID = Cx_Cle_Id

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

7090: AND CO.OBJECT1_ID1 = POA.AGENT_ID --CS.ID1
7091: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7092: AND CO.JTOT_OBJECT1_CODE = 'OKX_BUYER'
7093: and POA.AGENT_ID = PER.PERSON_ID
7094: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A
7095: WHERE A.PERSON_ID = PER.PERSON_ID);
7096:
7097:
7098: -- getting sales persons based contacts for contract line id.

Line 7158: PER_ALL_PEOPLE_F PER

7154: CURSOR Lx_Csr_emp_name(Cx_Resource_Id IN number) IS
7155: SELECT PER.FULL_NAME NAME
7156: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7157: FND_USER U ,
7158: PER_ALL_PEOPLE_F PER
7159: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7160: and U.USER_ID = RSC.USER_ID
7161: and RSC.RESOURCE_ID = Cx_Resource_Id
7162: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A

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

7158: PER_ALL_PEOPLE_F PER
7159: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7160: and U.USER_ID = RSC.USER_ID
7161: and RSC.RESOURCE_ID = Cx_Resource_Id
7162: and PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F A
7163: WHERE A.PERSON_ID = PER.PERSON_ID);
7164:
7165: -- for category 'PARTNER', 'PARTY'
7166: