APPS.JTF_RS_SRP_TERRITORIES_PVT dependencies on JTF_RS_SALESREPS

Line 98: FROM jtf_rs_salesreps

94:
95: CURSOR c_salesrep_details( l_salesrep_id IN NUMBER ) IS
96: SELECT start_date_active,
97: end_date_active
98: FROM jtf_rs_salesreps
99: WHERE SALESREP_ID = l_salesrep_id;
100:
101: CURSOR c_territory_details( l_territory_id IN NUMBER ) IS
102: SELECT start_date_active,

Line 629: FROM jtf_rs_salesreps jrs, jtf_rs_srp_territories jst

625:
626: CURSOR c_salesrep_details( l_salesrep_territory_id IN NUMBER ) IS
627: SELECT jrs.start_date_active,
628: jrs.end_date_active
629: FROM jtf_rs_salesreps jrs, jtf_rs_srp_territories jst
630: WHERE jrs.salesrep_id = jst.salesrep_id
631: AND jst.salesrep_territory_id = l_salesrep_territory_id;
632:
633: CURSOR c_territory_details( l_salesrep_territory_id IN NUMBER ) IS