APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SALESREPS

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

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

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

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

Line 1997: || ' cn_salesreps d '

1993: || ' '
1994: || 'FROM jtf_tae_1001_sc_winners a, '
1995: || ' jtf_terr_rsc_all b, '
1996: || ' jtf_terr_all c, '
1997: || ' cn_salesreps d '
1998: || 'WHERE a.terr_rsc_id = b.terr_rsc_id '
1999: || 'AND a.terr_id = c.terr_id '
2000: || 'AND a.resource_id = d.resource_id '
2001: || 'AND a.worker_id = '||p_worker_id;

Line 2737: || ' cn_salesreps e '

2733: || 'FROM jtf_tae_1001_sc_winners a, '
2734: || ' jtf_terr_rsc_all b, '
2735: || ' jtf_terr_all c, '
2736: || ' cn_comm_lines_api_all d, '
2737: || ' cn_salesreps e '
2738: || 'WHERE a.terr_rsc_id = b.terr_rsc_id '
2739: || 'AND a.terr_id = c.terr_id '
2740: || 'AND a.trans_object_id = d.comm_lines_api_id '
2741: || 'AND a.resource_id = e.resource_id '