APPS.CN_COLLECTION_AIA_OM_PUB dependencies on JTF_RS_SALESREPS

Line 32: FROM jtf_rs_salesreps

28: p_org_id cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.employee_number%TYPE IS
29:
30: cursor get_emp_num_cur IS
31: SELECT salesrep_number
32: FROM jtf_rs_salesreps
33: WHERE salesrep_id = p_salesrep_id
34: AND org_id = p_org_id;
35:
36: l_empnum_cr get_emp_num_cur%ROWTYPE;