DBA Data[Home] [Help]

APPS.CSF_ACCESS_PKG dependencies on JTF_TASKS_B

Line 439: , jtf_tasks_b jt_b

435: )
436: IS
437: SELECT hps.party_id
438: FROM hz_party_sites hps
439: , jtf_tasks_b jt_b
440: WHERE jt_b.source_object_id = x_incident_id
441: AND jt_b.source_object_type_code = 'SR'
442: AND jt_b.address_id = hps.party_site_id;
443:

Line 568: FROM jtf_tasks_b

564: ( x_task_id NUMBER
565: )
566: IS
567: SELECT source_object_id
568: FROM jtf_tasks_b
569: WHERE source_object_type_code = 'SR'
570: AND task_id = x_task_id;
571:
572: CURSOR c_task

Line 577: FROM jtf_tasks_b jt_b

573: ( x_task_id NUMBER
574: )
575: IS
576: SELECT task_id
577: FROM jtf_tasks_b jt_b
578: , jtf_task_types_b jtt_b
579: WHERE jt_b.task_id = x_task_id
580: AND jt_b.task_type_id = jtt_b.task_type_id
581: AND NVL(jt_b.deleted_flag, 'N') <> 'Y'

Line 882: FROM jtf_tasks_b

878: IS
879: SELECT source_object_id
880: , source_object_name
881: , source_object_type_code
882: FROM jtf_tasks_b
883: WHERE task_id = b_task_id;
884:
885: task_id NUMBER;
886:

Line 1272: This procedure acts as a trigger on JTF_TASKS_B

1268: Name:
1269: TASKS_TRIGGER_HANDLER
1270:
1271: Purpose:
1272: This procedure acts as a trigger on JTF_TASKS_B
1273: and is fired in case of insert, update or delete.
1274:
1275: Arguments:
1276: