APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on JTF_RS_SALESREPS

Line 163: FROM jtf_rs_salesreps s,

159: WHERE organization_id = p_org_id;
160:
161: CURSOR salesperson_name_csr IS
162: SELECT jtf_res.resource_name
163: FROM jtf_rs_salesreps s,
164: jtf_rs_resource_extns_vl jtf_res
165: WHERE s.salesrep_id = p_salesrep_id
166: AND s.resource_id = jtf_res.resource_id;
167:

Line 183: l_salesperson_name jtf_rs_salesreps.name%TYPE;

179:
180: l_doc_type_name okc_bus_doc_types_tl.name%TYPE;
181: l_cust_name hz_parties.party_name%TYPE;
182: l_ou_name hr_all_organization_units.name%TYPE;
183: l_salesperson_name jtf_rs_salesreps.name%TYPE;
184: l_trans_type_name oe_transaction_types_tl.name%TYPE;
185: l_sales_grp_name jtf_rs_groups_tl.group_name%TYPE;
186: l_con_admin_name per_all_people_f.full_name%TYPE;
187: l_not_available_text fnd_new_messages.message_text%TYPE;

Line 490: FROM jtf_rs_salesreps

486: AND header.max_version_flag = 'Y'
487: AND (p_cust_id IS NULL OR header.cust_party_id = p_cust_id)
488: AND (p_prev_con_admin_id IS NULL OR t.contract_admin_id = p_prev_con_admin_id)
489: AND (p_salesrep_id IS NULL OR header.resource_id = (SELECT resource_id
490: FROM jtf_rs_salesreps
491: WHERE salesrep_id = p_salesrep_id))
492: AND (p_org_id IS NULL OR header.org_id = p_org_id)
493: AND (p_order_type_id IS NULL OR header.order_type_id = p_order_type_id)
494: AND (p_sales_group_id IS NULL OR header.resource_grp_id = p_sales_group_id)