APPS.JTF_RESOURCE_UTL dependencies on JTF_RS_SALESREPS

Line 1148: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;

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

Line 1149: l_org_id jtf_rs_salesreps.org_id%TYPE;

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

Line 1153: FROM jtf_rs_salesreps

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

Line 1203: , jtf_rs_salesreps b

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

Line 1212: , jtf_rs_salesreps b

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

Line 1220: FROM jtf_rs_salesreps b

1216: ;
1217:
1218: CURSOR c_get_srp_start_date (l_salesrep_id IN NUMBER, l_org_id IN NUMBER) IS
1219: SELECT b.start_date_active
1220: FROM jtf_rs_salesreps b
1221: WHERE b.salesrep_id = l_salesrep_id
1222: AND b.org_id = l_org_id
1223: ;
1224:

Line 1227: FROM jtf_rs_salesreps b

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

Line 1337: FROM jtf_rs_salesreps

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

Line 1345: l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE;

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