[Home] [Help]
1491: cursor c_notes (v_task_asgn_id number) is
1492: select
1493: n.notes
1494: from
1495: jtf_notes_vl n,
1496: jtf_task_assignments a
1497: where
1498: n.source_object_code = 'TASK'
1499: and n.source_object_id = a.task_id
1500: and a.task_assignment_id = v_task_asgn_id
1501: union select
1502: n.notes
1503: from
1504: jtf_notes_vl n,
1505: jtf_task_assignments a,
1506: jtf_tasks_b t
1507: where
1508: n.source_object_code = 'SR'
1730: cursor c_notes (v_task_asgn_id number) is
1731: select
1732: n.notes
1733: from
1734: jtf_notes_vl n,
1735: jtf_task_assignments a
1736: where
1737: n.source_object_code = 'TASK'
1738: and n.source_object_id = a.task_id
1739: and a.task_assignment_id = v_task_asgn_id
1740: union select
1741: n.notes
1742: from
1743: jtf_notes_vl n,
1744: jtf_task_assignments a,
1745: jtf_tasks_b t
1746: where
1747: n.source_object_code = 'SR'
1969: cursor c_notes (v_task_id number) is
1970: select
1971: n.notes
1972: from
1973: jtf_notes_vl n
1974: where
1975: n.source_object_code = 'TASK'
1976: and n.source_object_id = v_task_id
1977: union select
1976: and n.source_object_id = v_task_id
1977: union select
1978: n.notes
1979: from
1980: jtf_notes_vl n,
1981: jtf_tasks_b t
1982: where
1983: n.source_object_code = 'SR'
1984: and n.source_object_id = t.source_object_id
2191: cursor c_notes (v_task_id number) is
2192: select
2193: n.notes
2194: from
2195: jtf_notes_vl n
2196: where
2197: n.source_object_code = 'TASK'
2198: and n.source_object_id = v_task_id
2199: union select
2198: and n.source_object_id = v_task_id
2199: union select
2200: n.notes
2201: from
2202: jtf_notes_vl n,
2203: jtf_tasks_b t
2204: where
2205: n.source_object_code = 'SR'
2206: and n.source_object_id = t.source_object_id