APPS.JTF_RS_TEAM_MEMBERS_PVT dependencies on DUAL

Line 252: /* If the resource type is INDIVIDUAL' then get the Employee Person Id

248: END IF;
249:
250:
251:
252: /* If the resource type is INDIVIDUAL' then get the Employee Person Id
253: from the Resource Extension table. */
254:
255: IF l_resource_type = 'INDIVIDUAL' THEN
256:

Line 255: IF l_resource_type = 'INDIVIDUAL' THEN

251:
252: /* If the resource type is INDIVIDUAL' then get the Employee Person Id
253: from the Resource Extension table. */
254:
255: IF l_resource_type = 'INDIVIDUAL' THEN
256:
257: OPEN c_employee_person_id(l_team_resource_id);
258:
259: FETCH c_employee_person_id INTO l_person_id;

Line 275: FROM dual;

271: /* Get the next value of the Team_member_id from the sequence. */
272:
273: SELECT jtf_rs_team_members_s.nextval
274: INTO l_team_member_id
275: FROM dual;
276:
277:
278: /* Insert the row into the table by calling the table handler. */
279:

Line 538: IF l_resource_type = 'INDIVIDUAL' THEN

534:
535: -- create wf_user_role record for the new team member
536: -- Don't care for its success status
537: BEGIN
538: IF l_resource_type = 'INDIVIDUAL' THEN
539: l_resource_id := l_team_resource_id;
540: l_group_id := NULL;
541: ELSE
542: l_resource_id := NULL;

Line 1366: IF l_resource_type = 'INDIVIDUAL' THEN

1362:
1363: -- delete wf_user_role record for the new team member
1364: -- Don't care for its success status
1365: BEGIN
1366: IF l_resource_type = 'INDIVIDUAL' THEN
1367: l_resource_id := l_team_resource_id;
1368: l_group_id := NULL;
1369: ELSE
1370: l_resource_id := NULL;