APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on JTF_TERR_RSC_ALL

Line 49: TYPE g_split_pctg_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;

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;
50:
51: TYPE g_rev_type_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;
52:
53: TYPE g_terr_name_tbl_type IS TABLE OF jtf_terr_all.NAME%TYPE;

Line 51: TYPE g_rev_type_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;

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;
50:
51: TYPE g_rev_type_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;
52:
53: TYPE g_terr_name_tbl_type IS TABLE OF jtf_terr_all.NAME%TYPE;
54:
55: TYPE g_del_flag_tbl_type IS TABLE OF VARCHAR2(1);

Line 1620: || ' jtf_terr_rsc_all b, '

1616: || ' b.'
1617: || l_ffname_rev_type
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 '

Line 2305: || ' jtf_terr_rsc_all b, '

2301: || ', '
2302: || ' ''N'', '
2303: || ' count(*) over(partition by d.comm_lines_api_id) '
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 '