APPS.CN_GET_TX_DATA_PUB dependencies on CN_SALESREPS

Line 58: cn_salesreps s

54: --
55: CURSOR api_cur IS
56: SELECT l.*, s.name
57: FROM cn_comm_lines_api_all l,
58: cn_salesreps s
59: WHERE comm_lines_api_id = p_comm_lines_api_id
60: AND l.salesrep_id = s.salesrep_id;
61: --
62: CURSOR header_cur IS

Line 65: cn_salesreps s

61: --
62: CURSOR header_cur IS
63: SELECT h.*,s.employee_number,s.name
64: FROM cn_commission_headers_all h,
65: cn_salesreps s
66: WHERE comm_lines_api_id = p_comm_lines_api_id
67: AND h.direct_salesrep_id = s.salesrep_id;
68: --
69: l_tbl_count NUMBER := 1;

Line 739: cn_salesreps s,

735: SELECT l.*,s.employee_number srp_employee_number,s.name,
736: clad.meaning adjust_status_disp,
737: clt.meaning trx_type_disp
738: FROM cn_comm_lines_api l,
739: cn_salesreps s,
740: cn_lookups clad,
741: cn_lookups clt
742: WHERE l.trx_type = clt.lookup_code(+)
743: AND clt.lookup_type (+)= 'TRX TYPES'

Line 757: cn_salesreps s,

753: SELECT h.*,s.employee_number,s.name,
754: clad.meaning adjust_status_disp,
755: clt.meaning trx_type_disp
756: FROM cn_commission_headers h,
757: cn_salesreps s,
758: cn_lookups clad,
759: cn_lookups clt
760: WHERE h.trx_type = clt.lookup_code(+)
761: AND clt.lookup_type (+)= 'TRX TYPES'