APPS.JTF_RS_RESOURCE_PVT dependencies on DUAL

Line 470: FROM dual;

466:
467: LOOP
468: SELECT jtf_rs_resource_extns_s.nextval
469: INTO l_resource_id
470: FROM dual;
471: --dbms_output.put_line ('After Select - Resource ID ' || l_resource_id);
472: OPEN c_dup_resource_id (l_resource_id);
473: FETCH c_dup_resource_id INTO l_check_dup_id;
474: EXIT WHEN c_dup_resource_id%NOTFOUND;

Line 486: FROM dual;

482: /* Get the next value of the Resource_number from the sequence. */
483:
484: SELECT jtf_rs_resource_number_s.nextval
485: INTO l_resource_number
486: FROM dual;
487:
488: /* Make a call to the Resource Audit API */
489:
490: jtf_rs_resource_extns_aud_pvt.insert_resource

Line 1428: FROM dual;

1424:
1425: LOOP
1426: SELECT jtf_rs_resource_extns_s.nextval
1427: INTO l_resource_id
1428: FROM dual;
1429: --dbms_output.put_line ('After Select - Resource ID ' || l_resource_id);
1430: OPEN c_dup_resource_id (l_resource_id);
1431: FETCH c_dup_resource_id INTO l_check_dup_id;
1432: EXIT WHEN c_dup_resource_id%NOTFOUND;

Line 1444: FROM dual;

1440: /* Get the next value of the Resource_number from the sequence. */
1441:
1442: SELECT jtf_rs_resource_number_s.nextval
1443: INTO l_resource_number
1444: FROM dual;
1445:
1446: /* Make a call to the Resource Audit API */
1447:
1448: jtf_rs_resource_extns_aud_pvt.insert_resource

Line 2265: WHERE role_resource_type = 'RS_INDIVIDUAL'

2261: IS
2262: SELECT min(start_date_active),
2263: max(end_date_active)
2264: FROM jtf_rs_role_relations
2265: WHERE role_resource_type = 'RS_INDIVIDUAL'
2266: AND role_resource_id = l_resource_id
2267: AND nvl(delete_flag, 'N') <> 'Y'
2268: AND end_date_active is not null;
2269:

Line 2276: WHERE role_resource_type = 'RS_INDIVIDUAL'

2272: l_resource_id IN NUMBER )
2273: IS
2274: SELECT min(start_date_active)
2275: FROM jtf_rs_role_relations
2276: WHERE role_resource_type = 'RS_INDIVIDUAL'
2277: AND role_resource_id = l_resource_id
2278: AND nvl(delete_flag, 'N') <> 'Y'
2279: AND end_date_active is null;
2280:

Line 2323: AND jrtm.resource_type = 'INDIVIDUAL'

2319: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
2320: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
2321: AND nvl(jrtm.delete_flag, 'N') <> 'Y'
2322: AND jrtm.team_resource_id = l_resource_id
2323: AND jrtm.resource_type = 'INDIVIDUAL'
2324: AND jrrr.end_date_active is not null;
2325:
2326:
2327: CURSOR c_team_mbr_role_dates_sec(

Line 2338: AND jrtm.resource_type = 'INDIVIDUAL'

2334: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
2335: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
2336: AND nvl(jrtm.delete_flag, 'N') <> 'Y'
2337: AND jrtm.team_resource_id = l_resource_id
2338: AND jrtm.resource_type = 'INDIVIDUAL'
2339: AND jrrr.end_date_active is null;
2340:
2341:
2342: CURSOR c_salesrep_dates_first(

Line 4200: WHERE role_resource_type = 'RS_INDIVIDUAL'

4196: IS
4197: SELECT min(start_date_active),
4198: max(end_date_active)
4199: FROM jtf_rs_role_relations
4200: WHERE role_resource_type = 'RS_INDIVIDUAL'
4201: AND role_resource_id = l_resource_id
4202: AND nvl(delete_flag, 'N') <> 'Y'
4203: AND end_date_active is not null;
4204:

Line 4211: WHERE role_resource_type = 'RS_INDIVIDUAL'

4207: l_resource_id IN NUMBER )
4208: IS
4209: SELECT min(start_date_active)
4210: FROM jtf_rs_role_relations
4211: WHERE role_resource_type = 'RS_INDIVIDUAL'
4212: AND role_resource_id = l_resource_id
4213: AND nvl(delete_flag, 'N') <> 'Y'
4214: AND end_date_active is null;
4215:

Line 4258: AND jrtm.resource_type = 'INDIVIDUAL'

4254: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4255: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4256: AND nvl(jrtm.delete_flag, 'N') <> 'Y'
4257: AND jrtm.team_resource_id = l_resource_id
4258: AND jrtm.resource_type = 'INDIVIDUAL'
4259: AND jrrr.end_date_active is not null;
4260:
4261:
4262: CURSOR c_team_mbr_role_dates_sec(

Line 4273: AND jrtm.resource_type = 'INDIVIDUAL'

4269: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4270: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4271: AND nvl(jrtm.delete_flag, 'N') <> 'Y'
4272: AND jrtm.team_resource_id = l_resource_id
4273: AND jrtm.resource_type = 'INDIVIDUAL'
4274: AND jrrr.end_date_active is null;
4275:
4276:
4277: CURSOR c_salesrep_dates_first(