APPS.CSF_MAINTAIN_GRP dependencies on JTF_TASK_STATUSES_B

Line 145: , jtf_task_statuses_b jtfts

141: select
142: tmp.object_id
143: from
144: jtf_tasks_b jtftk
145: , jtf_task_statuses_b jtfts
146: , jtf_task_types_b jttp
147: , JTF_OBJECT_PURGE_PARAM_TMP tmp
148: where
149: tmp.object_id = jtftk.source_object_id and

Line 613: , jtf_task_statuses_b jtfts

609: cac_sr_object_capacity cac
610: , JTF_TASKS_B tskt
611: , JTF_OBJECT_PURGE_PARAM_TMP tmp
612: , jtf_Task_assignments jtt
613: , jtf_task_statuses_b jtfts
614: WHERE
615: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
616: nvl(tmp.purge_status, 'S') <> 'E' and
617: tmp.object_id = tskt.source_object_id and

Line 627: jtf_Task_assignments jtts, jtf_task_statuses_b jtsts

623: nvl(jtfts.completed_flag,'N') = 'Y' or
624: nvl(jtfts.cancelled_flag,'N') = 'Y') and
625: cac.end_date_time < sysdate and
626: not exists (select 1 from
627: jtf_Task_assignments jtts, jtf_task_statuses_b jtsts
628: where
629: jtts.object_capacity_id = cac.object_capacity_id and
630: jtts.task_id <> jtt.task_id and
631: jtt.assignment_status_id = jtfts.task_status_id and

Line 658: , jtf_task_statuses_b jtfts

654: cac_sr_object_capacity cac
655: , JTF_TASKS_B tskt
656: , JTF_OBJECT_PURGE_PARAM_TMP tmp
657: , jtf_Task_assignments jtt
658: , jtf_task_statuses_b jtfts
659: WHERE
660: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
661: nvl(tmp.purge_status, 'S') <> 'E' and
662: tmp.object_id = tskt.source_object_id and