74: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
75: --Select the task status
76: Cursor status_cur is
77: select task_status_id, name
78: from jtf_task_statuses_vl
79: where task_status_id = 10;
80: --where name = 'Open';
81:
82: --Select the object code
360: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
361: --Select task status
362: Cursor status_cur is
363: select task_status_id, name
364: from jtf_task_statuses_vl
365: where task_status_id = 9;
366: --where name = 'Closed';
367:
368: --Select object code
517: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
518: --Select task status
519: Cursor status_cur is
520: select task_status_id, name
521: from jtf_task_statuses_vl
522: where task_status_id = 9;
523: --where name = 'Closed';
524:
525: --Select object code
658: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
659: --Select task status
660: Cursor update_status_cur is
661: select task_status_id, name
662: from jtf_task_statuses_vl
663: where task_status_id = 9;
664: --where name = 'Closed';
665:
666: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
666: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
667: --Select task_status
668: Cursor status_cur is
669: select task_status_id, name
670: from jtf_task_statuses_vl
671: where task_status_id = 10;
672: --where name = 'Open';
673:
674: -- Get source Object Details
785: -- Replaced name with seeded ids to avoid translation issues - Bug 1683539
786: --Select task status
787: Cursor delete_status_cur is
788: select task_status_id
789: from jtf_task_statuses_vl
790: where task_status_id = 10;
791: --where name = 'Open';
792:
793: --Select all the resolved time values for a given timevalue id