[Home] [Help]
5753: FROM
5754: sys.dual
5755: WHERE
5756: exists (SELECT NULL
5757: FROM pa_comp_rule_ot_defaults_all pcr, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5758: where pcr.project_id = p_project_id
5759: AND pcr.TASK_ID = st.task_id)
5760: or exists (SELECT NULL
5761: FROM pa_org_labor_sch_rule pol, table(cast(l_task_tbl as sub_task)) st