APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on JTF_TERR_ALL

Line 684: CURSOR client_info_csr IS select org_id from jtf_terr_all where terr_id = p_terr_id;

680: -- FROM DUAL;
681:
682:
683: --R12: mkothari -- added cursor to get territory org
684: CURSOR client_info_csr IS select org_id from jtf_terr_all where terr_id = p_terr_id;
685: l_terr_limited_to_ou VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OZF_TP_TERR_LIMITED_TO_OU'), 'N');
686:
687: BEGIN
688: --

Line 1917: FROM JTF_TERR_ALL JTR ,

1913: WHERE jtov.source_id = -1003
1914: AND parent_territory_id = 1;
1915: */
1916: select distinct JTR.terr_id
1917: FROM JTF_TERR_ALL JTR ,
1918: JTF_TERR_USGS_ALL JTU ,
1919: JTF_SOURCES_ALL JSE
1920: WHERE JTU.TERR_ID = JTR.TERR_ID
1921: AND JTU.SOURCE_ID = JSE.SOURCE_ID

Line 2002: CURSOR client_info_csr(l_terr_id NUMBER) IS select org_id from jtf_terr_all where terr_id = l_terr_id;

1998: AND r2.directional_flag = NVL(p_direction_code, r2.directional_flag)
1999: );
2000:
2001: -- R12
2002: CURSOR client_info_csr(l_terr_id NUMBER) IS select org_id from jtf_terr_all where terr_id = l_terr_id;
2003:
2004: BEGIN
2005: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start ');
2006: SAVEPOINT LOAD_PARTY_MARKET_QUALIFIER;