APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on JTF_TERR_ALL

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

50: TYPE g_split_pctg_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;
51:
52: TYPE g_rev_type_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;
53:
54: TYPE g_terr_name_tbl_type IS TABLE OF jtf_terr_all.NAME%TYPE;
55:
56: TYPE g_del_flag_tbl_type IS TABLE OF VARCHAR2(1);
57:
58: g_unloaded_txn_tbl g_rowid_tbl_type;

Line 1996: || ' jtf_terr_all c, '

1992: || l_ffname_rev_type
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 '

Line 2735: || ' jtf_terr_all c, '

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