DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on RA_SALESREPS_ALL

Line 5835: l_employee_id ra_salesreps_all.person_id%TYPE;

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

Line 5841: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa

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