APPS.JTF_RESOURCE_UTL dependencies on JTF_RS_SALESREPS

Line 1150: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;

1146: p_org_id IN NUMBER,
1147: x_return_status OUT NOCOPY VARCHAR2
1148: ) IS
1149:
1150: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
1151: l_org_id jtf_rs_salesreps.org_id%TYPE;
1152:
1153: CURSOR c_salesrep_id IS
1154: SELECT salesrep_id

Line 1151: l_org_id jtf_rs_salesreps.org_id%TYPE;

1147: x_return_status OUT NOCOPY VARCHAR2
1148: ) IS
1149:
1150: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
1151: l_org_id jtf_rs_salesreps.org_id%TYPE;
1152:
1153: CURSOR c_salesrep_id IS
1154: SELECT salesrep_id
1155: FROM jtf_rs_salesreps

Line 1155: FROM jtf_rs_salesreps

1151: l_org_id jtf_rs_salesreps.org_id%TYPE;
1152:
1153: CURSOR c_salesrep_id IS
1154: SELECT salesrep_id
1155: FROM jtf_rs_salesreps
1156: WHERE salesrep_id = p_salesrep_id
1157: -- NVL function for ORG_ID should be removed, as Multi-Org is mandatory for Release 11i.11.(MOAC changes)
1158: -- AND nvl (org_id,-99) = nvl (p_org_id,-99);
1159: AND org_id = p_org_id;

Line 1207: , jtf_rs_salesreps b

1203:
1204: CURSOR c_get_res_dates_cr (l_resource_id IN NUMBER, l_org_id IN NUMBER) IS
1205: SELECT a.start_date_active, nvl(a.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
1206: FROM jtf_rs_resource_extns a
1207: , jtf_rs_salesreps b
1208: WHERE a.resource_id = b.resource_id(+)
1209: AND a.resource_id = l_resource_id
1210: AND b.org_id(+) = l_org_id
1211: ;

Line 1216: , jtf_rs_salesreps b

1212:
1213: CURSOR c_get_res_dates_upd (l_salesrep_id IN NUMBER, l_org_id IN NUMBER) IS
1214: SELECT a.start_date_active, nvl(a.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
1215: FROM jtf_rs_resource_extns a
1216: , jtf_rs_salesreps b
1217: WHERE a.resource_id = b.resource_id
1218: AND b.salesrep_id = l_salesrep_id
1219: AND b.org_id = l_org_id
1220: ;

Line 1224: FROM jtf_rs_salesreps b

1220: ;
1221:
1222: CURSOR c_get_srp_start_date (l_salesrep_id IN NUMBER, l_org_id IN NUMBER) IS
1223: SELECT b.start_date_active
1224: FROM jtf_rs_salesreps b
1225: WHERE b.salesrep_id = l_salesrep_id
1226: AND b.org_id = l_org_id
1227: ;
1228:

Line 1231: FROM jtf_rs_salesreps b

1227: ;
1228:
1229: CURSOR c_get_srp_end_date (l_salesrep_id IN NUMBER, l_org_id IN NUMBER) IS
1230: SELECT NVL(b.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))
1231: FROM jtf_rs_salesreps b
1232: WHERE b.salesrep_id = l_salesrep_id
1233: AND b.org_id = l_org_id
1234: ;
1235:

Line 1341: FROM jtf_rs_salesreps

1337: ) IS
1338:
1339: CURSOR c_salesrep_number IS
1340: SELECT 'X'
1341: FROM jtf_rs_salesreps
1342: WHERE salesrep_number = p_salesrep_number
1343: -- NVL function for ORG_ID should be removed, as Multi-Org is mandatory for Release 11i.11.(MOAC changes)
1344: -- AND nvl(org_id,-99) = nvl(p_org_id,-99);
1345: AND org_id = p_org_id;

Line 1349: l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE;

1345: AND org_id = p_org_id;
1346:
1347: -- AND org_id = to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)));
1348:
1349: l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE;
1350: l_val VARCHAR2(1);
1351:
1352: BEGIN
1353: