[Home] [Help]
1481: cursor c_notes (v_task_asgn_id number) is
1482: select
1483: n.notes
1484: from
1485: jtf_notes_vl n,
1486: jtf_task_assignments a
1487: where
1488: n.source_object_code = 'TASK'
1489: and n.source_object_id = a.task_id
1490: and a.task_assignment_id = v_task_asgn_id
1491: union select
1492: n.notes
1493: from
1494: jtf_notes_vl n,
1495: jtf_task_assignments a,
1496: jtf_tasks_b t
1497: where
1498: n.source_object_code = 'SR'
1720: cursor c_notes (v_task_asgn_id number) is
1721: select
1722: n.notes
1723: from
1724: jtf_notes_vl n,
1725: jtf_task_assignments a
1726: where
1727: n.source_object_code = 'TASK'
1728: and n.source_object_id = a.task_id
1729: and a.task_assignment_id = v_task_asgn_id
1730: union select
1731: n.notes
1732: from
1733: jtf_notes_vl n,
1734: jtf_task_assignments a,
1735: jtf_tasks_b t
1736: where
1737: n.source_object_code = 'SR'
1959: cursor c_notes (v_task_id number) is
1960: select
1961: n.notes
1962: from
1963: jtf_notes_vl n
1964: where
1965: n.source_object_code = 'TASK'
1966: and n.source_object_id = v_task_id
1967: union select
1966: and n.source_object_id = v_task_id
1967: union select
1968: n.notes
1969: from
1970: jtf_notes_vl n,
1971: jtf_tasks_b t
1972: where
1973: n.source_object_code = 'SR'
1974: and n.source_object_id = t.source_object_id
2181: cursor c_notes (v_task_id number) is
2182: select
2183: n.notes
2184: from
2185: jtf_notes_vl n
2186: where
2187: n.source_object_code = 'TASK'
2188: and n.source_object_id = v_task_id
2189: union select
2188: and n.source_object_id = v_task_id
2189: union select
2190: n.notes
2191: from
2192: jtf_notes_vl n,
2193: jtf_tasks_b t
2194: where
2195: n.source_object_code = 'SR'
2196: and n.source_object_id = t.source_object_id