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 714: , jtf_task_statuses_b jtfts

710: cac_sr_object_capacity cac
711: , JTF_TASKS_B tskt
712: , JTF_OBJECT_PURGE_PARAM_TMP tmp
713: , jtf_Task_assignments jtt
714: , jtf_task_statuses_b jtfts
715: WHERE
716: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
717: nvl(tmp.purge_status, 'S') <> 'E' and
718: tmp.object_id = tskt.source_object_id and

Line 728: jtf_Task_assignments jtts, jtf_task_statuses_b jtsts

724: nvl(jtfts.completed_flag,'N') = 'Y' or
725: nvl(jtfts.cancelled_flag,'N') = 'Y') and
726: cac.end_date_time < sysdate and
727: not exists (select 1 from
728: jtf_Task_assignments jtts, jtf_task_statuses_b jtsts
729: where
730: jtts.object_capacity_id = cac.object_capacity_id and
731: jtts.task_id <> jtt.task_id and
732: jtt.assignment_status_id = jtfts.task_status_id and

Line 759: , jtf_task_statuses_b jtfts

755: cac_sr_object_capacity cac
756: , JTF_TASKS_B tskt
757: , JTF_OBJECT_PURGE_PARAM_TMP tmp
758: , jtf_Task_assignments jtt
759: , jtf_task_statuses_b jtfts
760: WHERE
761: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
762: nvl(tmp.purge_status, 'S') <> 'E' and
763: tmp.object_id = tskt.source_object_id and