APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SALESREPS

Line 43: TYPE g_salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE;

39: TYPE g_trans_object_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.trans_object_id%TYPE;
40:
41: TYPE g_terr_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.terr_id%TYPE;
42:
43: TYPE g_salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE;
44:
45: TYPE g_emp_no_tbl_type IS TABLE OF cn_salesreps.employee_number%TYPE;
46:
47: TYPE g_role_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.role_id%TYPE;

Line 45: TYPE g_emp_no_tbl_type IS TABLE OF cn_salesreps.employee_number%TYPE;

41: TYPE g_terr_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.terr_id%TYPE;
42:
43: TYPE g_salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE;
44:
45: TYPE g_emp_no_tbl_type IS TABLE OF cn_salesreps.employee_number%TYPE;
46:
47: TYPE g_role_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.role_id%TYPE;
48:
49: TYPE g_split_pctg_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;

Line 1622: || ' cn_salesreps d '

1618: || ' '
1619: || 'FROM jtf_tae_1001_sc_winners a, '
1620: || ' jtf_terr_rsc_all b, '
1621: || ' jtf_terr_all c, '
1622: || ' cn_salesreps d '
1623: || 'WHERE a.terr_rsc_id = b.terr_rsc_id '
1624: || 'AND a.terr_id = c.terr_id '
1625: || 'AND a.resource_id = d.resource_id '
1626: || 'AND a.worker_id = '||p_worker_id;

Line 2308: || ' cn_salesreps e '

2304: || 'FROM jtf_tae_1001_sc_winners a, '
2305: || ' jtf_terr_rsc_all b, '
2306: || ' jtf_terr_all c, '
2307: || ' cn_comm_lines_api_all d, '
2308: || ' cn_salesreps e '
2309: || 'WHERE a.terr_rsc_id = b.terr_rsc_id '
2310: || 'AND a.terr_id = c.terr_id '
2311: || 'AND a.trans_object_id = d.comm_lines_api_id '
2312: || 'AND a.resource_id = e.resource_id '