DBA Data[Home] [Help]

APPS.CN_COMM_LINES_API_PKG dependencies on CN_RS_SALESREPS

Line 2022: cn_rs_salesreps b

2018: CURSOR header_cur (l_commission_header_id NUMBER) IS
2019: SELECT a.*,
2020: b.salesrep_number employee_number
2021: FROM cn_commission_headers a,
2022: cn_rs_salesreps b
2023: WHERE a.direct_salesrep_id = b.salesrep_id AND
2024: a.commission_header_id = l_commission_header_id
2025: AND a.org_id = x_org_id
2026: AND a.org_id = b.org_id;