APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on JTF_TERR_RSC_ALL

Line 6: -- corresponds to JTF_TERR_RSC_ALL.RESOURCE_TYPE

2: /* $Header: ozfvalcb.pls 120.6.12010000.2 2008/08/08 08:53:37 ateotia ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_Fund_allocations_Pvt';
4:
5: -- yzhao 04/08/2003 fix bug 2897460 - RESOURCE GROUPS IN TERRITORY ADMIN NOT WORKING IN OMO
6: -- corresponds to JTF_TERR_RSC_ALL.RESOURCE_TYPE
7: G_RS_EMPLOYEE_TYPE CONSTANT VARCHAR2(30) := 'RS_EMPLOYEE';
8: G_RS_GROUP_TYPE CONSTANT VARCHAR2(30) := 'RS_GROUP';
9:
10: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

Line 90: FROM jtf_terr_rsc_all jtra,

86:
87: --R12 - Modified for Primary Contact - bug 4643041
88: CURSOR c_get_terr_owner IS
89: SELECT resource_id
90: FROM jtf_terr_rsc_all jtra,
91: jtf_terr_rsc_access_all jtraa
92: WHERE jtraa.terr_rsc_id = jtra.terr_rsc_id
93: AND jtraa.access_type = 'OFFER'
94: AND jtraa.trans_access_code = 'PRIMARY_CONTACT'

Line 894: l_terr_resource_type jtf_terr_rsc_all.resource_type%TYPE;

890: l_access_rec ams_access_pvt.access_rec_type;
891: l_mktelig_rec ams_act_market_segments_pvt.mks_rec_type;
892: l_segments_rec ams_act_market_segments_pvt.mks_rec_type;
893: l_terr_resource_id NUMBER;
894: l_terr_resource_type jtf_terr_rsc_all.resource_type%TYPE;
895: l_access_type ams_act_access.arc_user_or_role_type%TYPE;
896:
897: CURSOR c_check_access_exists(p_fund_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS
898: SELECT 1

Line 909: FROM jtf_terr_rsc_all jtra,

905:
906: --R12 - Modified for Primary Contact - bug 4643041
907: CURSOR c_get_territory_resource(p_terr_id NUMBER, p_primary_flag VARCHAR2) IS
908: SELECT jtra.resource_id, jtra.resource_type
909: FROM jtf_terr_rsc_all jtra,
910: jtf_terr_rsc_access_all jtraa
911: -- WHERE primary_contact_flag = p_primary_flag
912: WHERE jtraa.terr_rsc_id = jtra.terr_rsc_id
913: AND jtraa.access_type = 'OFFER'