394: WHERE s.site_use_id = p_site_use_id;
395:
396: CURSOR PRM_SALES_REP_CSR (p_source_object_id in number)is
397: select primary_salesrep_id
398: from ra_customer_trx_all
399: where customer_trx_id = p_source_object_id;
400:
401: CURSOR billto_contact_CSR (p_source_object_id in number)is
402: select bill_to_contact_id
399: where customer_trx_id = p_source_object_id;
400:
401: CURSOR billto_contact_CSR (p_source_object_id in number)is
402: select bill_to_contact_id
403: from ra_customer_trx
404: where customer_trx_id = p_source_object_id;
405: l_contact_id number;
406:
407: CURSOR contact_party_id_csr (p_contact_id in number) is