APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_TASK_REFERENCES_VL

Line 662: l_object_number jtf_task_references_vl.object_name%TYPE;

658:
659: l_api_name VARCHAR2(30) := 'Get_Doc_Details';
660:
661: l_select_statement varchar2(500) := NULL;
662: l_object_number jtf_task_references_vl.object_name%TYPE;
663: l_object_desc varchar2(1000);
664: l_doc_details_t varchar2(4000);
665: l_doc_details_h varchar2(4000);
666: l_resource_id NUMBER :=NULL;

Line 675: jtf_task_references_vl tr

671: SELECT jo.name object_type,
672: jo.object_code,
673: tr.object_name object_number
674: FROM jtf_objects_vl jo,
675: jtf_task_references_vl tr
676: WHERE tr.task_id = p_task_id
677: AND tr.object_type_code = jo.object_code
678: AND tr.reference_code = 'ESC';
679:

Line 1038: l_doc_number jtf_task_references_vl.object_name%TYPE;

1034: -- l_found VARCHAR2(1) := 'x';
1035: l_counter NUMBER(5);
1036: l_customer_name hz_parties.party_name%TYPE := NULL;
1037: l_event VARCHAR2(50) DEFAULT NULL;
1038: l_doc_number jtf_task_references_vl.object_name%TYPE;
1039: l_owner_name VARCHAR2(200);
1040: l_doc_type jtf_objects_vl.name%TYPE;
1041: l_doc_details_t VARCHAR2(4000);
1042: l_doc_details_h VARCHAR2(4000);

Line 1134: FROM jtf_task_references_vl

1130: -------------------------------------------------------------------------
1131:
1132: cursor c_esc_documents is
1133: SELECT object_name
1134: FROM jtf_task_references_vl
1135: WHERE task_id = p_task_id
1136: AND reference_code = 'ESC';
1137:
1138: