APPS.JTF_ASSIGN_PUB dependencies on JTF_TASK_REFERENCES_VL

Line 9510: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;

9506: l_effort_uom VARCHAR2(30);
9507:
9508: l_esc_source_code JTF_TASKS_VL.SOURCE_OBJECT_TYPE_CODE%TYPE;
9509: l_esc_source_id JTF_TASKS_VL.SOURCE_OBJECT_ID%TYPE;
9510: l_reference_code JTF_TASK_REFERENCES_VL.REFERENCE_CODE%TYPE;
9511:
9512: l_territory_id NUMBER;
9513: l_esc_territory_id NUMBER;
9514:

Line 9515: l_object_type_code JTF_TASK_REFERENCES_VL.OBJECT_TYPE_CODE%TYPE;

9511:
9512: l_territory_id NUMBER;
9513: l_esc_territory_id NUMBER;
9514:
9515: l_object_type_code JTF_TASK_REFERENCES_VL.OBJECT_TYPE_CODE%TYPE;
9516: l_object_id JTF_TASK_REFERENCES_VL.OBJECT_ID%TYPE;
9517:
9518: l_travel_time NUMBER := 0;
9519: l_travel_uom VARCHAR2(30) := 'HR';

Line 9516: l_object_id JTF_TASK_REFERENCES_VL.OBJECT_ID%TYPE;

9512: l_territory_id NUMBER;
9513: l_esc_territory_id NUMBER;
9514:
9515: l_object_type_code JTF_TASK_REFERENCES_VL.OBJECT_TYPE_CODE%TYPE;
9516: l_object_id JTF_TASK_REFERENCES_VL.OBJECT_ID%TYPE;
9517:
9518: l_travel_time NUMBER := 0;
9519: l_travel_uom VARCHAR2(30) := 'HR';
9520:

Line 9571: FROM jtf_task_references_vl

9567: CURSOR cur_reference_code IS
9568: SELECT reference_code,
9569: object_type_code,
9570: object_id
9571: FROM jtf_task_references_vl
9572: WHERE task_id = l_esc_id;
9573: l_cur_reference_code cur_reference_code%ROWTYPE;
9574: */
9575: