DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on PO_AGENTS

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

7374: AND CO.OBJECT1_ID1 = CS.RESOURCE_ID --CS.ID1
7375: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7376: AND CO.JTOT_OBJECT1_CODE = 'OKX_RESOURCE';
7377:
7378: -- getting po agents based contacts for contract id.
7379:
7380: CURSOR Lx_Csr_Chr_POAContacts(Cx_Chr_Id IN Gx_OKS_Id) IS
7381: SELECT PR.DNZ_CHR_ID CONTRACT_ID
7382: ,POA.AGENT_ID CONTACT_ID

Line 7387: FROM PO_AGENTS POA --OKX_BUYERS_V CS

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

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

7457: AND CO.OBJECT1_ID1 = CS.RESOURCE_ID --CS.ID1
7458: AND CO.OBJECT1_ID2 = '#' --CS.ID2
7459: AND CO.JTOT_OBJECT1_CODE = 'OKX_RESOURCE';
7460:
7461: -- getting po agents based contacts for contract line id.
7462:
7463: CURSOR Lx_Csr_Cle_POAContacts(Cx_Cle_Id IN Gx_OKS_Id,Cx_Chr_Id IN Gx_OKS_Id) IS
7464: SELECT PR.DNZ_CHR_ID CONTRACT_ID
7465: ,POA.AGENT_ID CONTACT_ID

Line 7470: FROM PO_AGENTS POA --OKX_BUYERS_V CS

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