APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on HZ_LOCATIONS

Line 1219: * THIS IS WRONG AND SHOULD BE REMOVED. MAP SHOULD BE USING HZ_LOCATIONS TABLE.

1215: *
1216: * 4. If the Assignnment goes to Working (as per the new status), then it means
1217: * that the Resource is working on the Task and so his location should be updated
1218: * to reflect the location of the Task. This is required by Map Functionality.
1219: * THIS IS WRONG AND SHOULD BE REMOVED. MAP SHOULD BE USING HZ_LOCATIONS TABLE.
1220: *
1221: * @param p_api_version API Version (1.0)
1222: * @param p_init_msg_list Initialize Message List
1223: * @param p_commit Commit the Work

Line 1539: FROM jtf_tasks_b t, hz_locations l

1535: and seeded_flag= 'Y';
1536:
1537: CURSOR c_task_geometry(p_task_id number) IS
1538: SELECT l.geometry
1539: FROM jtf_tasks_b t, hz_locations l
1540: WHERE t.task_id = p_task_id
1541: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
1542:
1543: