DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on RA_SALESREPS_ALL

Line 5706: l_employee_id ra_salesreps_all.person_id%TYPE;

5702:
5703:
5704: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5705: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
5706: l_employee_id ra_salesreps_all.person_id%TYPE;
5707: l_user_name wf_users.name%TYPE;
5708: l_display_name wf_users.display_name%TYPE;
5709:
5710: CURSOR c (p_id IN NUMBER) IS

Line 5712: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa

5708: l_display_name wf_users.display_name%TYPE;
5709:
5710: CURSOR c (p_id IN NUMBER) IS
5711: SELECT rsa.person_id
5712: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa
5713: WHERE rcta.primary_salesrep_id = rsa.salesrep_id
5714: AND rcta.customer_trx_id = p_id;
5715:
5716: BEGIN