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 740: cn_salesreps s,

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

Line 758: cn_salesreps s,

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