5831:
5832:
5833: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5834: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
5835: l_employee_id ra_salesreps_all.person_id%TYPE;
5836: l_user_name wf_users.name%TYPE;
5837: l_display_name wf_users.display_name%TYPE;
5838:
5839: CURSOR c (p_id IN NUMBER) IS
5837: l_display_name wf_users.display_name%TYPE;
5838:
5839: CURSOR c (p_id IN NUMBER) IS
5840: SELECT rsa.person_id
5841: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa
5842: WHERE rcta.primary_salesrep_id = rsa.salesrep_id
5843: AND rcta.customer_trx_id = p_id;
5844:
5845: BEGIN