1084: IS
1085:
1086:
1087: CURSOR l_thirdparty_csr (p_id Number) IS
1088: SELECT Party_Id From OKX_CUST_SITE_USES_V
1089: WHERE ID1 = p_id;
1090:
1091: CURSOR l_cust_csr (p_contactid Number) IS
1092: SELECT Party_Id From OKX_CUST_CONTACTS_V
3441: From OKX_CTR_ASSOCIATIONS_V
3442: Where Source_Object_Id = p_id;
3443:
3444: Cursor l_billto_csr (p_billto Number) Is
3445: Select cust_account_id from OKX_CUST_SITE_USES_V
3446: where id1 = p_billto and id2 = '#';
3447:
3448: Cursor l_ra_hcontacts_cur (p_contact_id number) Is
3449: Select hzr.object_id, hzr.party_id