DBA Data[Home] [Help]

APPS.JTF_RS_SRP_TERRITORIES_PVT dependencies on RA_TERRITORIES

Line 104: FROM ra_territories

100:
101: CURSOR c_territory_details( l_territory_id IN NUMBER ) IS
102: SELECT start_date_active,
103: end_date_active
104: FROM ra_territories
105: WHERE TERRITORY_ID = l_territory_id;
106:
107: BEGIN
108:

Line 636: FROM ra_territories rt, jtf_rs_srp_territories jst

632:
633: CURSOR c_territory_details( l_salesrep_territory_id IN NUMBER ) IS
634: SELECT rt.start_date_active,
635: rt.end_date_active
636: FROM ra_territories rt, jtf_rs_srp_territories jst
637: WHERE rt.territory_id = jst.territory_id
638: AND jst.salesrep_territory_id = l_salesrep_territory_id;
639:
640: BEGIN