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 2266: WHERE role_resource_type = 'RS_INDIVIDUAL'

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

Line 2277: WHERE role_resource_type = 'RS_INDIVIDUAL'

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

Line 2324: AND jrtm.resource_type = 'INDIVIDUAL'

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

Line 2339: AND jrtm.resource_type = 'INDIVIDUAL'

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

Line 4191: WHERE role_resource_type = 'RS_INDIVIDUAL'

4187: IS
4188: SELECT min(start_date_active),
4189: max(end_date_active)
4190: FROM jtf_rs_role_relations
4191: WHERE role_resource_type = 'RS_INDIVIDUAL'
4192: AND role_resource_id = l_resource_id
4193: AND nvl(delete_flag, 'N') <> 'Y'
4194: AND end_date_active is not null;
4195:

Line 4202: WHERE role_resource_type = 'RS_INDIVIDUAL'

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

Line 4249: AND jrtm.resource_type = 'INDIVIDUAL'

4245: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4246: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4247: AND nvl(jrtm.delete_flag, 'N') <> 'Y'
4248: AND jrtm.team_resource_id = l_resource_id
4249: AND jrtm.resource_type = 'INDIVIDUAL'
4250: AND jrrr.end_date_active is not null;
4251:
4252:
4253: CURSOR c_team_mbr_role_dates_sec(

Line 4264: AND jrtm.resource_type = 'INDIVIDUAL'

4260: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4261: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4262: AND nvl(jrtm.delete_flag, 'N') <> 'Y'
4263: AND jrtm.team_resource_id = l_resource_id
4264: AND jrtm.resource_type = 'INDIVIDUAL'
4265: AND jrrr.end_date_active is null;
4266:
4267:
4268: CURSOR c_salesrep_dates_first(