APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_ALL

Line 31: -- 08/22/01 ARPATEL Added JTF_TERR_ALL start/end date checks in cursor C_GetTerrRsc

27: -- 05/03/01 ARPATEL Specify table entries for
28: -- x_QualifyingRsc_out_tbl in proc
29: -- Get_Escalation_TerrMembers
30: -- 07/16/01 ARPATEL Changed to a 'for loop' construct in Get_Escalation_TerrMembers
31: -- 08/22/01 ARPATEL Added JTF_TERR_ALL start/end date checks in cursor C_GetTerrRsc
32: --
33: -- End of Comments
34: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfptrgb.pls';
35:

Line 3898: FROM jtf_terr_all jt

3894: /* modified for R12 as there is no concept of escalation territory for R12 , instead */
3895: /* resources will be assigned to the territory as escalation owner */
3896: /* SELECT jt.escalation_territory_id */
3897: SELECT jt.terr_id
3898: FROM jtf_terr_all jt
3899: WHERE jt.terr_id = p_terr_id
3900: AND NVL(jt.end_date_active, sysdate+1) > sysdate
3901: AND NVL(jt.start_date_active, sysdate-1) < sysdate;
3902:

Line 4077: FROM jtf_terr_all jt

4073: /* cursor to return escalation terr id */
4074: CURSOR c_parent_terr_id ( p_terr_id NUMBER )
4075: IS
4076: SELECT jt.parent_territory_id
4077: FROM jtf_terr_all jt
4078: WHERE jt.terr_id = p_terr_id;
4079:
4080: /* cursor return vraiable */
4081: par_csr NUMBER;

Line 4265: JTF_TERR_ALL JT

4261: JTR.ROLE,
4262: JTR.PRIMARY_CONTACT_FLAG
4263: From JTF_TERR_RSC_ALL JTR,
4264: --JTF_TERR_RSC_ACCESS JTRA,
4265: JTF_TERR_ALL JT
4266: Where JT.TERR_ID = p_Terr_id
4267: AND JTR.TERR_ID = JT.TERR_ID
4268: --AND JTR.TERR_RSC_ID = JTRA.TERR_RSC_ID (+)
4269: AND NVL(jtr.end_date_active, sysdate+1) > sysdate