DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on PO_AGENTS

Line 6990: -- getting po agents based contacts for contract id.

6986: AND CO.OBJECT1_ID1 = CS.RESOURCE_ID --CS.ID1
6987: AND CO.OBJECT1_ID2 = '#' --CS.ID2
6988: AND CO.JTOT_OBJECT1_CODE = 'OKX_RESOURCE';
6989:
6990: -- getting po agents based contacts for contract id.
6991:
6992: CURSOR Lx_Csr_Chr_POAContacts(Cx_Chr_Id IN Gx_OKS_Id) IS
6993: SELECT PR.DNZ_CHR_ID CONTRACT_ID
6994: ,POA.AGENT_ID CONTACT_ID

Line 6999: FROM PO_AGENTS POA --OKX_BUYERS_V CS

6995: ,'PO_AGENT' RSC_CATEGORY
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

Line 7073: -- getting po agents based contacts for contract line id.

7069: AND CO.OBJECT1_ID1 = CS.RESOURCE_ID --CS.ID1
7070: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7071: AND CO.JTOT_OBJECT1_CODE = 'OKX_RESOURCE';
7072:
7073: -- getting po agents based contacts for contract line id.
7074:
7075: CURSOR Lx_Csr_Cle_POAContacts(Cx_Cle_Id IN Gx_OKS_Id,Cx_Chr_Id IN Gx_OKS_Id) IS
7076: SELECT PR.DNZ_CHR_ID CONTRACT_ID
7077: ,POA.AGENT_ID CONTACT_ID

Line 7082: FROM PO_AGENTS POA --OKX_BUYERS_V CS

7078: ,'PO_AGENT' RSC_CATEGORY
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