APPS.PA_RESOURCE_PVT dependencies on DUAL

Line 267: FROM dual

263: -- Bug 4350723 - change to where exists to improve performance.
264:
265: SELECT 'Y'
266: INTO l_rows_exists
267: FROM dual
268: WHERE EXISTS (SELECT 'Y'
269: FROM pa_resources_denorm
270: WHERE l_resource_denorm_rec.person_id = person_id
271: AND l_resource_denorm_rec.job_id = job_id);

Line 495: -- If resource_effective_start_date has been passed, update an individual

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: -------------------------------------------------------------------------
495: -- If resource_effective_start_date has been passed, update an individual
496: -- record after some appropriate validations.
497: -- Since the combination of person_id and resource_effective_start_date is
498: -- the primary key in the table 'PA_RESOURCES_DENORM', resource_effective
499: -- _start_date should not be null for individual record update.

Line 499: -- _start_date should not be null for individual record update.

495: -- If resource_effective_start_date has been passed, update an individual
496: -- record after some appropriate validations.
497: -- Since the combination of person_id and resource_effective_start_date is
498: -- the primary key in the table 'PA_RESOURCES_DENORM', resource_effective
499: -- _start_date should not be null for individual record update.
500: -------------------------------------------------------------------------
501: IF l_resource_denorm_new_rec.resource_effective_start_date <> FND_API.G_MISS_DATE AND
502: l_resource_denorm_new_rec.resource_effective_start_date is not null THEN
503:

Line 504: -- Update individual record.

500: -------------------------------------------------------------------------
501: IF l_resource_denorm_new_rec.resource_effective_start_date <> FND_API.G_MISS_DATE AND
502: l_resource_denorm_new_rec.resource_effective_start_date is not null THEN
503:
504: -- Update individual record.
505: update_single_res_denorm_rec (
506: p_resource_denorm_rec => l_resource_denorm_new_rec,
507: x_return_status => l_return_status,
508: x_err_msg_code => l_err_msg_code );

Line 788: FROM dual

784: --FROM pa_resources_denorm
785: --WHERE person_id=p_new_resource_denorm_rec.person_id;
786:
787: SELECT 'Y' INTO l_name_changed
788: FROM dual
789: WHERE exists
790: (SELECT 'Y'
791: FROM pa_resources_denorm
792: WHERE person_id = p_new_resource_denorm_rec.person_id

Line 1223: FROM dual;

1219: , sysdate
1220: , TO_NUMBER(FND_GLOBAL.USER_ID)
1221: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1222: , p_person_type
1223: FROM dual;
1224: --end null location
1225: END IF;
1226: -- end first time
1227: END IF;

Line 1344: FROM dual;

1340: , sysdate
1341: , TO_NUMBER(FND_GLOBAL.USER_ID)
1342: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1343: , p_person_type
1344: FROM dual;
1345: END LOOP;
1346:
1347: CLOSE denormalized_locations;
1348: