1654: cursor c1 is
1655: SELECT 1
1656: FROM sys.dual
1657: WHERE EXISTS (SELECT NULL
1658: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1659: WHERE project_id = x_project_id)
1660: UNION
1661: SELECT 1
1662: FROM sys.dual
1667: cursor c2 is
1668: SELECT 1
1669: FROM sys.dual
1670: where exists (SELECT NULL
1671: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1672: where project_id = x_proj_id
1673: AND TASK_ID IN
1674: (SELECT TASK_ID
1675: FROM PA_TASKS
1706: SELECT 1
1707: FROM sys.dual
1708: WHERE
1709: exists (SELECT NULL
1710: FROM pa_comp_rule_ot_defaults_all
1711: where project_id = x_proj_id
1712: AND TASK_ID = x_task_id)
1713: or exists (SELECT NULL
1714: FROM pa_org_labor_sch_rule