502: WHERE tk.source_object_id = p_object_id
503: AND tk.source_object_type_code = p_object_type_code
504: AND tk.deleted_flag ='N'
505: AND (EXISTS (SELECT o.object_id
506: FROM jtf_object_mappings o
507: WHERE o.object_id = TO_CHAR(tk.task_type_id)
508: AND o.source_object_code = 'ASO_QUOTE')
509: OR NOT EXISTS ( SELECT om.object_id
510: FROM JTF_OBJECT_MAPPINGS om
506: FROM jtf_object_mappings o
507: WHERE o.object_id = TO_CHAR(tk.task_type_id)
508: AND o.source_object_code = 'ASO_QUOTE')
509: OR NOT EXISTS ( SELECT om.object_id
510: FROM JTF_OBJECT_MAPPINGS om
511: WHERE om.object_id = TO_CHAR(tk.task_type_id)));
512:
513: BEGIN
514: