APPS.PA_STATUS_PUB dependencies on DUAL

Line 2260: select 'Y' into l_rollup from dual

2256:
2257: IF G_TASK_PROGRESS_in_tbl(i).OBJECT_TYPE = 'PA_ASSIGNMENTS'
2258: THEN
2259: begin
2260: select 'Y' into l_rollup from dual
2261: where exists (select 1 from pa_percent_completes
2262: where task_id = l_TASK_ID
2263: AND PROJECT_ID = l_project_id_out
2264: and object_type = 'PA_TASKS'