APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on JTF_TERR_ALL

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

674: -- FROM DUAL;
675:
676:
677: --R12: mkothari -- added cursor to get territory org
678: CURSOR client_info_csr IS select org_id from jtf_terr_all where terr_id = p_terr_id;
679: l_terr_limited_to_ou VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OZF_TP_TERR_LIMITED_TO_OU'), 'N');
680:
681: BEGIN
682: --

Line 1904: FROM JTF_TERR_ALL JTR ,

1900: WHERE jtov.source_id = -1003
1901: AND parent_territory_id = 1;
1902: */
1903: select distinct JTR.terr_id
1904: FROM JTF_TERR_ALL JTR ,
1905: JTF_TERR_USGS_ALL JTU ,
1906: JTF_SOURCES_ALL JSE
1907: WHERE JTU.TERR_ID = JTR.TERR_ID
1908: AND JTU.SOURCE_ID = JSE.SOURCE_ID

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

1985: AND r2.directional_flag = NVL(p_direction_code, r2.directional_flag)
1986: );
1987:
1988: -- R12
1989: CURSOR client_info_csr(l_terr_id NUMBER) IS select org_id from jtf_terr_all where terr_id = l_terr_id;
1990:
1991: BEGIN
1992: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start ');
1993: SAVEPOINT LOAD_PARTY_MARKET_QUALIFIER;