DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on DUAL

Line 2243: select 'Y' into l_rollup from dual

2239:
2240: IF G_TASK_PROGRESS_in_tbl(i).OBJECT_TYPE = 'PA_ASSIGNMENTS'
2241: THEN
2242: begin
2243: select 'Y' into l_rollup from dual
2244: where exists (select 1 from pa_percent_completes
2245: where task_id = l_TASK_ID
2246: AND PROJECT_ID = l_project_id_out
2247: and object_type = 'PA_TASKS'