APPS.JTF_ASSIGN_PUB dependencies on JTF_TASK_REFERENCES_VL

Line 9574: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;

9570: l_effort_uom VARCHAR2(30);
9571:
9572: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
9573: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
9574: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;
9575:
9576: l_territory_id NUMBER;
9577: l_esc_territory_id NUMBER;
9578:

Line 9579: l_object_type_code JTF_TASK_REFERENCES_VL.OBJECT_TYPE_CODE%TYPE;

9575:
9576: l_territory_id NUMBER;
9577: l_esc_territory_id NUMBER;
9578:
9579: l_object_type_code JTF_TASK_REFERENCES_VL.OBJECT_TYPE_CODE%TYPE;
9580: l_object_id JTF_TASK_REFERENCES_VL.OBJECT_ID%TYPE;
9581:
9582: l_travel_time NUMBER := 0;
9583: l_travel_uom VARCHAR2(30) := 'HR';

Line 9580: l_object_id JTF_TASK_REFERENCES_VL.OBJECT_ID%TYPE;

9576: l_territory_id NUMBER;
9577: l_esc_territory_id NUMBER;
9578:
9579: l_object_type_code JTF_TASK_REFERENCES_VL.OBJECT_TYPE_CODE%TYPE;
9580: l_object_id JTF_TASK_REFERENCES_VL.OBJECT_ID%TYPE;
9581:
9582: l_travel_time NUMBER := 0;
9583: l_travel_uom VARCHAR2(30) := 'HR';
9584:

Line 9635: FROM jtf_task_references_vl

9631: CURSOR cur_reference_code IS
9632: SELECT reference_code,
9633: object_type_code,
9634: object_id
9635: FROM jtf_task_references_vl
9636: WHERE task_id = l_esc_id;
9637: l_cur_reference_code cur_reference_code%ROWTYPE;
9638: */
9639: