DBA Data[Home] [Help]

APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKX_CUST_CONTACTS_V

Line 657: from okx_cust_contacts_v

653: ----new
654: Cursor cur_cust_acct_id(p_chr_id in NUMBER,
655: p_billto_id in NUMBER) is
656: Select cust_acct_id
657: from okx_cust_contacts_v
658: where party_id in
659: (select object1_id1 from okc_k_party_roles_b
660: where dnz_chr_id = p_chr_id--:PARAMETER.OKSDEFLT_CHR_ID
661: and chr_id = p_chr_id--:PARAMETER.OKSDEFLT_CHR_ID

Line 691: FROM OKX_CUST_CONTACTS_V

687:
688:
689: Cursor Get_Contact_Cust_Acct ( l_contact_id IN nUMBER)IS
690: Select cust_acct_id
691: FROM OKX_CUST_CONTACTS_V
692: WHERE ROLE_TYPE = 'CONTACT'
693: AND ID1 = l_contact_id ;
694:
695: