APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on JTF_TERR_ALL

Line 53: TYPE g_terr_name_tbl_type IS TABLE OF jtf_terr_all.NAME%TYPE;

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);
56:
57: g_unloaded_txn_tbl g_rowid_tbl_type;

Line 1621: || ' jtf_terr_all c, '

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 '
1625: || 'AND a.resource_id = d.resource_id '

Line 2306: || ' jtf_terr_all c, '

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 '
2310: || 'AND a.terr_id = c.terr_id '